The Index Usage Analysis Details window displays information about the retrieve of the query plan for each SQL statement.
The Index Usage Analysis Details window displays after the batch run process is completed unless the Show details on next batch run checkbox in the Index Usage Analysis Details window is unchecked.
To review the Index Usage Analysis Details window after an analysis
Select View | Show Index Usage Analysis Details when the Index Usage Analysis window is active.
Review this information to see if an error occurred during the retrieval of the query plan. Errors may occur if the selected SQL statements are from one database and user and you have set another database and user in the drop-down boxes at the bottom left of the main window.
You can only modify the analysis name and description.
To modify an Analysis
Select the Analyzer you want to modify from the left pane.
Right-click and select Modify.
Modify the name and/or description.
You can rename an analysis in the Index Usage Analyzer window in two ways.
To rename an Analysis
Note: You can also right-click and select Modify. Modify the name.
To delete an analysis
Select the analysis you want to delete in the left pane.
Right-click and select Delete.