15.10 - Defining a Workload from an Existing Workload - Teradata Index Wizard

Teradata Index Wizard User Guide

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

You can create a new workload using the information from an existing workload. You can add statements from existing workloads, existing QCD statements, or statement text.

1 Click Workload > Create > From an Existing Workload.

The Create from Existing Workload dialog box opens.

2 Select the workload using the QCD and workload fields.

For more information, see “To create a new workload from an existing workload” on page 69.

3 Select the type of statement to add in the Add Statements area by selecting the appropriate option button, and click Browse.

The Add Workload Statements dialog box opens. See Table 19 on page 71.

4 Choose the statements to add, and click Add To List.

The selected statements are added to the main list of statements. For more information, see “Adding Additional Workload Statements” on page 70.

5 In the New Workload Name box, type the name of the new workload.

6 Click Create.

The Workload Summary window appears showing the new workload summary.

7 Check to ensure the workload is correct, 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.

The following table explains the Create from Existing Workload dialog box.

 

Window Option

Description

Workload Statements

QCD Name

Enter the QCD name to be browsed for SQL statements.

Workload Name

Enter the workload or click to browse for workloads.

Statement

Shows the Query ID, frequency, and statement text.

Add Statements

Add Statement

Use Add Statements to add additional statements to an existing workload. The Browse button opens a dialog box based on the additional workload statement source. Use the dialog box to select the additional statement.

Types of statements include:

  • QCD Statements
  • Statement Text
  • Other Workloads
  • For information about these dialog boxes, see “Adding Additional Workload Statements” on page 70.

    Click to open a window based on the workload choice.

    Note: Only highlighted statements are included in the workload definition.

    New Workload Name

    Names the new workload.

    Create

    Creates the new workload with the selected statements.