Defining a Workload from an Existing Workload - Teradata Index Wizard

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.