15.10 - Schedule Recommendation - Teradata Index Wizard

Teradata Index Wizard User Guide

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

Index Wizard allows you to schedule when an index recommendation is applied to the production database. This feature uses Teradata Query Scheduler to schedule requests.

Note: The schedule recommendation feature only works with Teradata Query Scheduler 15.00 and above. If Creation > Schedule Recommendations is dimmed, Teradata Query Scheduler might not be installed or properly set up. For more information, refer to the Teradata Query Scheduler Administrator Guide.

1 Click Creation > Schedule Recommendations.

The Select Recommendations dialog box appears.

2 Fill in the dialog box as follows.

 

Dialog Box 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

Indicates 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.

3 Select the recommendation to be executed, and click Next.

The Schedule Recommendations dialog box appears.

4 Fill in the dialog box as follows.

 

Option

Description

Scheduling Options

Specifies the parameters for scheduling the recommendations.

Request Name

Type a name for the request.

User ID

Indicates the User ID on which the Teradata Query Scheduler session was created. This is the same as the current user ID specified at logon.

Start Date

Specify the date when the recommendations is to be executed.

Start Time

Specify the time when the execution of the recommendations begins.

Maximum Wait Time

Specify the maximum time up to which the start of execution can be deferred if an execution window is not available at the specified time.

5 Click Schedule to schedule the recommendation at the specified date and time.

6 A message appears with the Request Id number and Job Id number. Make note of these numbers, and click OK.

7 To view your request, open the Teradata Query Scheduler Viewer. Look in the list for your Request Id and Job Id numbers.

Note: If you receive an error, see “Schedule Recommendation Errors” on page 132.