Analyze Notes

Quick Way to Analyze a Table/Index
ANALYZE TABLE|CLUSTER|INDEX schema.name ESTIMATE|COMPUTE STATISTICS SAMPLE n ROWS|PERCENT;
Using DBMS_STATS Package
exec DBMS_STATS.GATHER_TABLE_STATS(ownname='owner', tabname=>'table_name', estimate_percent=>5, method_opt=>'FOR ALL INDEXED COLUMNS SIZE 1', block_sample=>TRUE, degree=>8, granularity=>'GLOBAL|ALL', cascade=>TRUE);

For the meaning of each parameter and other possible parameters, look at $ORACLE_HOME/rdbms/admin/dbmsstat.sql for the program documentation.