Reviewing the SQL Access Advisor Recommendations: Summary

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

To review the recommendations summary: 

1. On the Results for Tasks page, click Summary.

   The Summary subpage of the Results for Tasks page appears.

2. Under Overall Workload Performance, assess the potential for improvement in implementing the recommendations.

3. Use the Workload I/O Cost chart to compare the original workload I/O cost with the new cost.

4. 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 will improve 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 will improve by the projected improvement factor are along the vertical axis (0% to 100%).

5. Under Recommendations, click Show Recommendation Action Counts.

6. Under SQL Statements, click Show Statement Counts to display the type of SQL statement.