Collect Index Statistics example
In Oracle database to collect an index statistics you must use the command alter index with REBUILD COMPUTE STATISTICS keyword.
-- Collect Index Statistics ALTER INDEX STU_LN_IDX REBUILD COMPUTE STATISTICS;
Output:
index STU_LN_IDX altered.