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
Related Q&A from Don Burleson
I have created a table, Party, and in it there are two main fields, party_code and party_name, and around 2,500 records are available in it. I passed... Continue Reading
Suppose you have a table which has only two columns, namely locid (not primary) and place. In Oracle, which query should I run to get the output as ... Continue Reading
I have a query that retrieves around 10 records. I have a task to concatenate the values separated with ','. I would like to know if Oracle has any ... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.