How the Tools Relate

The SQL Access Advisor examines a group of SQL statements and provides advice to improve performance in the form of

  • Creating indexes.
  • Creating materialized views and materialized view logs.
  • Implementing partitioning strategies.

One key feature of the SQL Access Advisor is that it analyzes the entire SQL workload as a set and makes recommendations that improve the overall performance of the workload. In other words, this tool will recommend creating an index that improves the performance of SQL statement, but only if it does not significantly reduce the performance of other INSERT, UPDATE, and DELETE statements contained in the workload.

Segue to the SQL Tuning Advisor; this tool analyzes one or more SQL statements and provides ...

Get Expert Indexing in Oracle Database 11g: Maximum Performance for Your Database now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.