Analyze table can typically specify analysis: Table, all fields, all indexed fields, all indexes. If not specified, all are analyzed.
sql> Analyze table my_table compute statistics;
sql> Analyze table my_table compute Statistics for table for all indexes ;
sql> Analyze table my_table compute Statistics for all indexes to all indexed ;
which
sql> Analyze table my_table compute statistics;
Equivalent to:
sql> Analyze table my_table compute Statistics for all indexes to all columns ;
Sample
Analyze table T1 compute statistics for table;
Analyze table T2 Compute statistics for all columns;
Analyze table T3 compute statistics for all indexed columns;
Analyze Table T5 Compute statistics for all indexes;
analyze table T4 compute statistics; (not specified)
In addition, you can delete profiling data:
sql> Analyze table my_table Delete statistics;
sql> Analyze table my_table Delete statistics for table for all indexes to all indexed;
Excerpt from: http://www.cnblogs.com/einyboy/archive/2012/08/09/2630321.html