How to Analyze a Table or Index in Oracle Using the Analyze Statement
Here are a few examples of how to analyze a table and index. ANALYZE TABLE SAMPLE_TABLE COMPUTE STATISTICS; –completely computes statistics ANALYZE INDEX SAMPLE_TABLE_PK COMPUTE STATISTICS; –completely computes statistics ANALYZE TABLE SAMPLE_TABLE ESTIMATE STATISTICS SAMPLE 100 ROWS; –estimates statistics based on the set number of rows ANALYZE TABLE SAMPLE_TABLE ESTIMATE STATISTICS SAMPLE 15 PERCENT; –estimates statistics [...]