Generating index recommendations

This task is about generating and viewing the index recommendations.

Procedure

To generate index recommendations:

  1. Create a tuning task on single query or workload, with Recommend new indexes tuning option selected.
  2. When the tuning task is completed, go to Tuning > Tuning results page to view the result list.
  3. In the Tuning results page, select the tasks with the Result displaying as Success and click View result.
    The Advisor recommendations page displays.
  4. Click Indexes from the Advisors menu.
    The Storage comparison chart, Performance comparison chart, and Index recommendations table are displayed.

    The Storage comparison chart and Performance comparison chart provide a comparison between the original cost and the after-change cost if index recommendations are applied.

  5. From the index table list, you can select all indexes or select only certain rows of recommendations to run.