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. |
