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 wizard has two pages to select the options for changing an analysis before it is updated. It is not necessary to make any changes on these pages before rerunning the analysis.
On the Analyzer page, you can change the name and description of the analysis.
On the Selected SQL page, you can add or delete SQL statements to the analysis.
When the analysis is finished, the Index Usage Analysis Details window appears with information the retrieve of the access plan for each SQL statement.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center