Oracle INDEX Compute Statistics

The Oracle analyze index compute statistics command:

ANALYZE INDEX index_name COMPUTE STATISTICS;

The Oracle analyze index validate structure command:

ANALYZE INDEX index_name VALIDATE STRUCTURE;

Compute Statistics

ALTER INDEX index_name REBUILD COMPUTE STATISTICS;

Related Links:

ALTER INDEX REBUILD

Oracle / PLSQL: Indexes