Reviewing the SQL Access Advisor Recommendations: Recommendations

The Recommendations subpage ranks the SQL Access Advisor recommendations by cost improvement. You can also view details about each recommendation.

To review recommendation details: 

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

   The Recommendations subpage appears.

2. Use the Recommendations by Cost Improvement chart to view recommendations ordered by the cost improvement.

   Under Select Recommendations for Implementation, each recommendation is listed with its implementation status, recommendation ID, cost improvement, space consumption, and the number of affected SQL statements for each recommendation. Implementing the top recommendation will have the biggest benefit to the total performance of the workload.

3. To view details for a particular recommendation, select the recommendation and click Recommendation Details.

   The Recommendation Details page appears.

   The Recommendation Details page displays all actions for the specified recommendation.

   Under Actions, you can choose to modify the schema name, tablespace name, and storage clause for each action. To view the SQL text of an action, click the link in the Action column for the specified action.

   Under SQL Affected by Recommendation, the SQL text of the SQL statement and cost improvement information are displayed.

4. Click OK.

   The Recommendations subpage appears.

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

   The Show SQL page for the selected recommendation appears.