Workload Analysis Report - Teradata Index Wizard

Workload Analysis Report

The Workload Analysis Report shows the cost estimate of a workload and the relative execution cost of a workload compared to the entire workload, statement text, frequency, and column types. The report also shows the tables and columns referenced, statements with clauses, and columns with join conditions.

Note: For each statement, multiple rows exist in the report, one row per table.

This report is created when a workload is defined.

To open the Workload Analysis Report

✔ Select Reports > Current Workload > Workload Analysis Report.

The following table explains the information in this report.

Column Name	Description
Statement Type	Shows the type of the statement.
Cost Estimate (hh:mm:ss:sss)	Shows the original cost of the statement with the recommended indexes.
Relative Cost	Shows the execution cost of the statement with respect to the execution cost of the entire workload.
Database Name	Shows the name of the database used to generate the report.
Table Name	Shows the tables accessed by the statement.
Value Access Columns	Shows the columns accessed by the statement in the table.
Join Columns	Shows the columns that are used in join conditions in the statements.
Range Access Columns	Shows the columns accessed in range condition.
Frequency	Shows the frequency of the statement.
Statement Text	Shows the text of the SQL statement.