The Existing Indexes Report provides a general view of the information about the table including index type, unique flags, and index names. This report is created when a workload is defined.
– or –
From the Reports toolbar, select 
The following table explains the information in the report.
|
Column Name |
Description |
|
Database Name |
Shows the name of the database. |
|
Table Name |
Shows the name of individual tables. |
|
Columns |
Shows the list of columns (comma separated), which comprises the index. |
|
Index Type |
Shows the type of the index including: |
|
Unique Flag |
Indicates whether the index is unique or not. |
|
Index Name |
Shows the name of the index, if present. |
|
Index Number |
Shows the number of the index. |
|
Index Used |
Shows if an index is used in the workload. |
|
Query Text |
Shows the text of the SQL statement. |