Reviewing the SQL Access Advisor Recommendations: Summary

The Summary subpage displays an overview of the SQL Access Advisor analysis.

To review the recommendations summary:

Access the Results for Task page, as described in "Reviewing the SQL Access Advisor Recommendations".
Click Summary.

The Summary subpage of the Results for Tasks page appears.

In this example, Limited Mode is selected so that SQL Access Advisor analyzes the highest cost statements rather than all statements.

Description of the illustration sql_access_results_summary.gif
Under Overall Workload Performance, assess the potential for improvement in implementing the recommendations.
Use the Workload I/O Cost chart to compare the original workload I/O cost with the new cost.

In this example, the workload I/O cost decreases from 107.1 million to 43.1 million by implementing the recommendations.
Use the Query Execution Time Improvement chart to compare the improvement in query execution time.

This chart shows the percentage of SQL statements in the workload whose execution time improves by accepting the recommendations. The SQL statements are grouped by the projected improvement factor along the horizontal axis on the chart (1x to >10x). The percentage of SQL statements that improve by the projected improvement factor are along the vertical axis (0% to 100%).

In this example, approximately 62 percent of SQL statements in the workload do not improve execution time, but about 25 percent have the potential for improvement of over 4x or more.
Under Recommendations, click Show Recommendation Action Counts.

In the following example, creating 2 indexes, 4 materialized views, and 4 materialized view logs is recommended.

Description of the illustration sql_access_results_reccount.gif
Under SQL Statements, click Show Statement Counts to display the type of SQL statement.

In the following example, 25 SELECT statements are analyzed.

Description of the illustration sql_access_results_sqlcount.gif