Reviewing the SQL Access Advisor Recommendations: SQL Statements

The SQL Statements subpage ranks SQL statements in the workload by cost improvement. You can use this page to view details about the SQL statements analyzed in the workload.

To review SQL statements: 

1. On the Results for Tasks page, click SQL Statements.

   The SQL Statements subpage appears.

2. Use the SQL Statements by Cost Improvement chart to view SQL statements in the workload ordered by the cost improvement.

   Under Select SQL Statements to be Improved, each SQL statement is listed with its statement ID, SQL text, associated recommendation, cost improvement, and execution count.

   Implementing the recommendation associated with the top SQL statement will have the biggest benefit to the total performance of the workload. 1052

3. To view the SQL text of a recommendation, select the recommendation and click Show SQL.

   The Show SQL page for the selected recommendation appears.