15.10 - Index Maintenance Cost 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 Maintenance Cost Report shows the estimated cost of maintaining recommended indexes for a particular recommendation ID on a workload. This report contains a row for every SQL statement and recommended index combination where maintenance costs are required for the index.

Note: This is not applicable for Partition Analysis.

This report is created after a workload is analyzed.

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

    Note: This report will not contain any rows if none of the recommended indexes require any maintenance cost.

     

    Column Name

    Description

    Database Name

    Name of the database in which base table name is defined.

    Table Name

    The base table in the IndexRecommendations table on which the index is defined.

    QueryID

    The QueryID value of the SQL UPDATE statement.

    To view the corresponding workload statement, right-click on the QueryID.

    Index Type

    The type of recommended index.

    Maintenance Cost
    (hh:mm:ss.sss)

    Estimated cost for updating the index structures.

    Index DDL

    The DDL statement text of the recommended index.