Description of the illustration sql_tuning_auto_stats.gif

The Overall Task Statistics and Profile Effect Statistics section are shown.

The Overall Task Statistics section has the following name-value pairs: Executions is 2, Candidate SQL is 145, Distinct SQL Examined is 24.

The section has two charts: the SQL Examined Status pie chart and the Breakdown by Finding Type bar chart.

In the SQL Examined Status pie chart, 75% of the area is SQL Examined With Findings and 25% is SQL Examined Without Findings. Below the chart is a legend, each value of which is a link. The values of the legend are: SQL Examined With Findings (18), SQL Examined Without Findings (6), and SQL Skipped Due to Errors (0).

The Breakdown by Finding Type bar chart has Number of SQL along the y-axis. The range is from 0 to 12. The legend next to the chart has two categories: Implemented (green) and Not Implemented (blue). Along the x-axis are four bars. The label of each bar is a link. The labels and the height of each bar are the following: SQL Profile is 5, Index is 2, Statistics is 10, Restructure SQL is 4. All bars are solid blue.

The Profile Effect Statistics section has a bar chart. The title of the chart is Workload Potential DB Time Benefit (seconds per week). Under the title are two label-value pairs: Implemented (sec) is 0, Potential (sec) is 64. The y-axis is DB Time (s) and ranges from 0 to 75. The x-axis is two labels: Implemented and Recommended. The legend is Before (navy blue) and After (light blue). Implemented has no bars. Recommended has Before at 65 and After at 5.

End of description.