Summary
The SQL Access Advisor tool can be invoked to tune one SQL statement or a group of statements. This tool provides advice regarding the creation of indexes, materialized views, materialized view logs, and partitioning strategies. Because one of the main outputs of this tool is index creation advice, we decided it should be covered in this book on indexing strategies.
The DBMS_ADVISOR.QUICK_TUNE procedure specifically provides tuning advice for a single query. If you are required to tune a collection of SQL statements, use the Enterprise Manager SQL Access Advisor Wizard. This tool allows you to efficiently choose from a vast set of SQL Access Advisor options when tuning a group of SQL statements. As part of its output, you can view the ...
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.
