Use DBMS_ADVISOR’s quick_tune for indexing advice

(Bob Watkins) One of the best features of Oracle 10g is its Advisory Framework, which is a collection of tuning advisors that help you get the most out of your database. One of these advisors, the SQL Access Advisor, can recommend changes in your schema’s indexing or materialized views to improve pe

Read More - Register for Free Membership