15.10 - Index Recommendation 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 Index Recommendation Report shows the recommended secondary index for each table if one is recommended. Use the information in this table to help you make a decision about whether the index recommended is appropriate or not. The report also suggests indexes that can be dropped.

The statistics used for the analysis are saved in the Index Recommendations table.

This report is created after a workload is analyzed.

  • Select Reports > Current Workload > Index Recommendation...
  • The following table describes the information provided in the report.

     

    Column Name

    Description

    Database Name

    Shows the database for the table.

    Table Name

    Shows the name of the table on which the index was recommended.

    Index Type

    Shows the type of index recommended, for example a Hash-Ordered Secondary Index.

    Time Estimate
    (hh:mm:sss:sss)

    Shows the time estimate to actually create the recommended index.

    Note: This is an empty string for partition analysis recommendations.

    Index DDL

    Shows the DDL statement text used to create/drop the index.

    Stats DDL

    Shows the DDL statements used to collect statistics.