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 displays in the right pane.
Item | Description |
Top Pane - Summary Information |
Displays a summary of the indexes in the table that are used or unused. |
Middle Pane - Index Used Information |
Displays the indexes used by the SQL statement. |
Bottom Left Pane - SQL Text |
Displays the text of the SQL statement. |
Bottom Right Pane - SQL Information |
Displays the query plan, abstract plan, traceon information, 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. Use the Right-click menu to Save the list of indexes or Drop Index.
Item | Description |
Definition Tab |
Displays when and where the table was created. |
Columns Tab |
Displays the column information for the table. |
Index Tab |
Displays the index information for the table. |
DDL Tab |
Displays the DDL for creating the table and indexes. |
In the Index Usage Analyzer window, when the SQL Analyzed folder is selected in the left pane, the following information displays in the right pane.
Displays all the SQL statements and shows the tables and indexes used.
When a SQL statement is selected in the left pane, the following information displays in the right pane.
Displays general information about the analysis, information on the connection used to retrieve the query plans and the database settings at the time of the analysis.
Displays the query plan and the SQL Information pane.
Displays the table name, the index name, and the index key for the indexes used by the SQL statement. Use the Right-click menu to Save the list of indexes.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Nutzungsbedingungen Datenschutz Cookie Preference Center