You can update an analysis for unused indexes by rerunning the analysis with the same SQL statements from the original analysis or you can add or delete SQL statements from the analysis.
To update an analysis
Right-click the analysis name in the left pane of the Index Usage Analysis window and select Update Analysis. The Update Analysis window has two tabs to select the options for changing an analysis before it is updated. It is not necessary to make any changes on these tabs before rerunning the analysis.
On the Analyzer tab, you can change the name and description of the analysis.
On the Selected SQL tab, you can add or delete SQL statements to the analysis.
After making the selections from the two tabs, click OK.
When the analysis is finished, the Index Usage Analysis Details window displays with information the retrieve of the query plan for each SQL statement.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
