Q

Packages and commands for cost-based optimization

What PL/SQL packages and commands are better for cost-based optimization?

What PL/SQL packages and what commands are better for a DBA to use for cost-based optimization?
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
This Content Component encountered an error

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close