If you are on Oracle 8i and beyond, you should always use dbms_stats to collect statistics. The "analyze table" command is ancient from Oracle 7, and it gives really bad statistics, especially for partitioned tables, et cetera. By the way, if you want to save schema statistics, use the dbms_stats.export_schema_stats procedure. Here is a good link: http://www.dba-oracle.com/art_orafaq_cbo_stats.htm
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.