Adding Additional Workload Statements - Teradata Index Wizard

Teradata Index Wizard User Guide

Product
Teradata Index Wizard
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2506
Product Category
Teradata Tools and Utilities

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.