15.10 - Defining a Workload - Teradata Index Wizard

Teradata Index Wizard User Guide

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

The starting point for the index recommendation process is capturing a representative sample of active SQL statements. This is done by defining a a set of queries as a workload. Typically, a workload is comprised of a set of queries from a production system.

Teradata Index Wizard provides the following ways to define a workload:

  • Selecting queries from the DBQL.
  • Keying in the SQL statement manually. The SQL statements can also be selected from one or more files.
  • Using an existing set of execution plans from the user defined QCD.
  • Importing SQL statements from a file.
  • Creating a new workload from an existing one.
  • 1 Select Workload > Create and choose a workload definition method.

    The types of definitions are shown below. For specific procedures about each workload definition method, click on the following types:

  • Defining a Workload From DBQL Statements
  • Defining a Workload Using Statement Text
  • Defining a Workload From QCD Statements
  • Importing a Workload
  • Defining a Workload from an Existing Workload
  • Defining a Workload from DBQL XML Statements
  • Updating an Existing Workload
  • 2 Fill in the dialog box as needed.

    After the workload is created, it is stored, and a summary window opens showing the workload.

    3 Click OK to complete the workload definition step.

    After a workload is created, it stays in the workload cache and is used by default in the analysis, reports, and validations steps.

    The following reports are available after the workload is defined:

  • Existing Indexes Report
  • Update Frequency Report
  • Table Usage Analysis Report
  • Workload Analysis Report
  • Table Scan Report
  • 4 Go to the next step, “Running an Analysis” on page 41

    For more information on workloads, see Chapter 5: “Workload Definition.”