What is the preferred way of reverting back to using the analyze command for updating statistics once dbms_stats has been executed on the tables?

    Requires Free Membership to View

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

This was first published in October 2004

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: