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:
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:
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:
4 Go to the next step, “Running an Analysis” on page 41
For more information on workloads, see Chapter 5: “Workload Definition.”