15.10 - Executing a Recommendation Immediately - Teradata Index Wizard

Teradata Index Wizard User Guide

prodname
Teradata Index Wizard
vrm_release
15.10
category
User Guide
featnum
B035-2506-035K

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.