Defining a Workload - 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

A workload is a set of SQL statements created or defined using the Workload Definition dialog box. Teradata Index Wizard creates several workload reports after a workload is defined.

Workloads can be defined in the following ways:

  • Using Database Query Log (DBQL) - The Database Query Log (DBQL) provides the capability to store, in system tables, the performance-related data for a request.
  • For more information, see “Defining a Workload From DBQL Statements” on page 53.

  • Using Statement Text - SQL statements can be directly keyed into a workload. The SQL statements can also be selected from one or more files.
  • For more information, see “Defining a Workload Using Statement Text” on page 58.

  • From QCD Statements - An existing set of execution plans in a QCD can be selected to form a workload. The workload is created in the QCD in which the execution plans exist.
  • For more information, see “Defining a Workload From QCD Statements” on page 60.

  • Importing Workload - Users can import workloads from other sources including other Teradata client tools.
  • For more information, see “Importing a Workload” on page 63.

  • From an Existing Workload - A new workload can be created from an existing workload.
  • For more information, see “Defining a Workload from an Existing Workload” on page 69.

  • Using Database XML Query Log (DBQL) - The Database XML Query Log (DBQL XML) provides the capability to store the performance-related data for a request into system tables.
  • For more information, see “Defining a Workload from DBQL XML Statements” on page 71.

    After the workload is defined, it is analyzed. See Performing Analysis.