Index Maintenance Cost Report - Teradata Index Wizard

Teradata Index Wizard User Guide

Teradata Index Wizard
Release Number
English (United States)
Last Update
Product Category
Teradata Tools and Utilities

Index Maintenance Cost Report

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.

To open the Index Maintenance Cost Report

✔ 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


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.


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

Estimated cost for updating the index structures.

Index DDL

The DDL statement text of the recommended index.