Summary Report - Teradata Index Wizard

Teradata Index Wizard User Guide

Product
Teradata Index Wizard
Release Number
15.00
Language
English (United States)
Last Update
2018-09-28
dita:id
B035-2506
lifecycle
previous
Product Category
Teradata Tools and Utilities

Summary Report

The Summary Report provides details about the secondary index counts and recommendation counts made in a specific analysis for all tables in the workload. This report is created after a workload is analyzed.

The footnote on the report shows the statement count in the workload, number of tables accessed by the workload, and the time analysis.

The report also shows the table name in which the index must be created or dropped and the DDL statement for creating/dropping the index.

The statement text of the query ID can be viewed by right-clicking the QueryID column.

To open the Summary Report

✔ Select Reports > Create Workload > Summary Report.

The following table explains the information in this report.

 

Column Name

Description

Analysis Type

Shows the type of analysis

Query ID

The ID assigned to the query.

Database Name

Shows the name of the database.

Table Name

Shows the name of the table.

No. of Secondary Indexes

Shows the number of existing secondary indexes.

No. of Join Indexes

Shows the number of existing join indexes.

No. of Index Recommendations

Shows the number of index recommendations provided for the particular table.

To view the DDL for the index recommendations, right-click on No. of Index Recommendations.