15.10 - Selecting Reports - Teradata Index Wizard

Teradata Index Wizard User Guide

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

When a workload is created or an index analysis completed, a series of reports are generated. This section gives a brief overview of each report. For more about reports, see Chapter 7: “Reports.”

1 Select Reports > Current Workload.

A new window opens with the available reports shown on the left side of the window.

2 Click a report name to view the report.

The following table briefly describes each report and shows its associated tree menu icon.

 

Icon

Report Name and Description

For More Information

Index Recommendations Report

Displays information about the recommended set of indexes for the tables in the workload.

“Index Recommendation Report” on page 116

Existing Indexes Report

Displays information on the existing set of indexes for the tables in the workload.

“Existing Indexes Report” on page 112

Query Cost Analysis Report

Displays the execution cost improvement for the SQL statements with the recommended set of indexes.

“Query Cost Analysis Report” on page 117

Update Frequency Report

Displays the relative number of updates on a given table in the workload when compared to the number of accesses from the table.

“Update Frequency Report” on page 113

Disk Space Analysis Report

Displays the estimated space required to store the recommended indexes.

“Disk Space Analysis Report” on page 118

Index Maintenance Cost Report

Displays the estimated cost of maintaining recommended indexes for a particular recommendation ID on a workload.

“Index Maintenance Cost Report” on page 119

Table Usage Analysis Report

Displays the usage of tables within the workload.

“Table Usage Analysis Report” on page 113

Table Scan Report

This report contains information about the usage of tables in the workload. It aids the user in selecting tables over which the set of indexes will be recommended. Table cardinality (estimates), access types, and geographies can give clues as to where an index might be of value.

“Table Scan Report” on page 114

Object Global Use Count Report

Shows the objects that are accessed the most on a table.

“Object Global Use Count Report” on page 115

Workload Analysis Report

This report provides a statement-wise analysis of the workload.

“Workload Analysis Report” on page 114

Summary Report

This report shows details about the secondary index count and recommendation count made in a specific analysis for all tables in a workload.

“Summary Report” on page 118

Go to the next step, “Validating Recommendations” on page 44.