Analyze Notes

<< Replication Push Example | Journals | Recovery Manager (RMAN) 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.