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 based on the set percentage of rows
