In the Index Usage Analyzer window, when an Analyzer is selected in the left pane, the following information displays in the right pane.
Displays the total number of indexes in the tables used in all the selected SQL statements and the number of used and unused indexes. Charts the percentage of the indexes that are used by the query plans for the selected SQL statements.
The detailed information about the Analysis displays in the button pages. The buttons for displaying specific information are found at the top of this pane.
Properties button
Displays general information about the analysis, information on the connection used to retrieve the query plans and the SQL statements used in the analysis.
Displays the indexes that are used by the selected SQL statements in black text and highlights in red the indexes that are not used. Use the Right-click menu to Save the list of indexes or Drop Index.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center
