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
DELETE statements contained in the workload.
Segue to the SQL Tuning Advisor; this tool analyzes one or more SQL statements and provides ...