Defining a Workload - Teradata Index Wizard

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.”