Obtaining Advice for a Group of SQL Statements
To make full use of the SQL Access Advisor features, we strongly recommend you use the Enterprise Manager SQL Access Advisor Wizard. This browser-based interface allows you to visually select from a vast number of features and options. Using this graphical tool is much more efficient than trying to manually generate the code required when using the DBMS_ADVISOR PL/SQL package. Keep in mind that you can always view and modify the PL/SQL that Enterprise Manager generates if you need to fine-tune the code to meet your requirements.
In the next several paragraphs we demonstrate an example that generates indexing advice for the SQL currently running in memory. First, log in to Enterprise Manager and navigate ...
Get Expert Indexing in Oracle Database 11g: Maximum Performance for Your Database now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
