This task is about generating and viewing the index recommendations.
Procedure
To generate index recommendations:
- Create a tuning task on single query or workload, with Recommend new indexes
tuning option selected.
- When the tuning task is completed, go to
page
to view the result list.
- In the Tuning results page, select the tasks with the Result displaying as
Success and click View result.
The Advisor recommendations
page displays.
- 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.
- From the index table list, you can select all indexes or select only certain rows of
recommendations to run.