Packages and commands for cost-based optimization

What PL/SQL packages and what commands are better for a DBA to use for cost-based optimization?

    Requires Free Membership to View

    Login

If you are using Oracle 9i or 10g, then the only PL/SQL package for optimizer statistics is the DBMS_STATS package. Read more information on this package here.

Do not use the old ANALYZE TABLE or ANALYZE INDEX to generate optimizer statistics anymore. The DBMS_STATS package does a much better job and it has more features.

This was first published in February 2007

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top