Existing Indexes Report - Teradata Index Wizard

Existing Indexes Report

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.

To open the existing indexes report

✔ Select Reports > Current Workload > Existing Indexes Report.

– or –

From the Reports toolbar, select .

✔ Use the Reports toolbar to manage the report.

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: Primary Secondary Join Unique primary index Hash index Cover index Hash-ordered secondary index Value-ordered secondary index Partition primary index
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.