Collect Index Statistics

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.