15.10 - Defining a Workload Using Statement Text - Teradata Index Wizard

Teradata Index Wizard User Guide

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

SQL statements can be typed in or selected from one or more files. All text specified up to a semi-colon followed by a new line without any additional text is considered a single request. After the workload is defined, the execution plans are captured in the specified QCD.

You can set the sample size for collecting statistics on the tables prior to creating a workload. The statistics are collected into the QCD while capturing the execution plans for the workload statements. Go to Tools > Options > Preferences, and select the General tab.

1 Select Workload > Create > Using Statement Text.

The Define Workload using Statements dialog box opens.

2 Set the criteria for defining the workload by filling in the dialog box.

The following table describes the fields and buttons in this dialog box.

 

Field/Button

Description

SQL Statements

SQL Statement

Type the SQL statement to be analyzed or select a file by clicking Browse.

Frequency

Specifies the number of times the statement gets executed in the workload. The default value is 1.

Add

Adds the SQL statement written in the SQL Statement box to the workload.

Browse

Browses the file which contains the SQL statements.

Selected Statements

QCD Name

Specifies the QCD on which the captured workload is created. Click to search existing QCDs.

Workload Name

Creates a name for the workload to be created.

Frequency

Displays the frequency of each SQL statement that has been added.

Statement Text

Displays the text of the SQL statement.

Remove

Removes the selected SQL statements.

Replace

Replaces the selected statement with the statement in the edit box.

3 Click OK to start the workload definition process.

Note: If the QCD name you previously entered does not exist, a message appears asking if you want to create the QCD. Click Yes to create the QCD, or click No to select an existing QCD.

When the process is complete, the Workload Definition Summary window opens.

If errors occur while creating a workload, see “Errors While Defining a Workload” on page 62.

4 Check the workload, and click OK.

The workload is now in the workload cache and is ready to be analyzed. For more information, see “Chapter 6 Analysis” on page 81.