Executing a Recommendation Immediately - Teradata Index Wizard

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

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.

Option	Description
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.
Execute	Executes the selected recommendations and displays the results of the execution.