15.10 - Adding Additional Workload Statements - Teradata Index Wizard

Teradata Index Wizard User Guide

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

There are several ways to add statements to the new workload including:

  • QCD Statements
  • Statement Text
  • Other Workloads
  • The following table explains each option.

     

    Table 19: Add Workload Statements Dialog Box Description 

    Window Option

    Description

    QCD Statements

    Query ID
    Query tag

    Enter the Query ID or Query tag of the statement you want to add. Click to look for existing workloads in the QCD.

    Click Add to List to add the statements.

    SQL Statements

    SQL Statements field

    Enter the SQL statements you want to add to the workload in the field

    Use the Browse button to add statements from a file.

    Use the Frequency box to indicate the frequency of statements with in workload.

    Click Add to add the workloads to the Selected Statements field.

    Click Add to List to add the statements.

    Other Workloads

    Workload Name

    Enter a workload name, or click Browse to get a list of existing workloads.

    Statements field

    Shows the statements to be added.

    Click Add to List to add the statements.