In the Index Usage Analyzer window, when a table is selected under the Tables Analyzed section is selected in the left pane, the following information is displayed in the right pane.
Pane |
Function |
Description |
---|---|---|
Top |
Summary Information |
Displays a summary of the indexes in the table that are used or unused. |
Middle |
Index Used Information |
Displays the indexes used by the SQL statement. |
Bottom Left |
SQL Text |
Displays the text of the SQL statement. |
Bottom Right |
SQL Information |
Displays the access plan, SQL Classification, and the temporary table DDL for the selected SQL statement in the SQL Information pane. |
Lists the indexes and the key for all indexes in the table that are not used.
To save a list of all the unused indexes
Right-click and select Save.
In the Save Format window, select Text, HTML, or Excel Convertible (Spreadsheet).
To drop an index
Right-click the line with the index you want to drop and select Drop Index.
Tab |
Description |
---|---|
Definition |
Displays when and where the table was created. |
Columns |
Displays the column information for the table. |
Index |
Displays the index information for the table. |
DDL |
Displays the DDL for creating the table and indexes. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center