15.10 - Summary Report - Teradata Index Wizard

Teradata Index Wizard User Guide

prodname
Teradata Index Wizard
vrm_release
15.10
category
User Guide
featnum
B035-2506-035K

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.

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