Executing a Recommendation Immediately - Teradata Index Wizard

Teradata Index Wizard User Guide

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

Executing a Recommendation Immediately

The execute immediately option allows you to apply an index recommendation immediately to a production system.

To execute a recommendation immediately

1 Click Creation > Execute Immediately.

The Execute Recommendations dialog box appears.

2 Fill in the dialog box as needed.

The following table describes the options in this dialog box.

3 Click Execute to begin the execution process.




QCD Name

Enter the QCD name or click to display a list.

Workload Name

Enter the name of the Workload or click to display the list of workloads in the QCD.

Index Tag

Select an index tag.

Table Name

Shows the table name where the recommendation must be executed.

Statement Text

Displays the DDL text of the index recommendations, as well as COLLECT/DROP STATISTICS statements.

Select All

Selects all the recommendations.

Deselect All

Deselects all the recommendations.


Executes the selected recommendations and displays the results of the execution.