Additional Index Wizard Features - Teradata Index Wizard

Teradata Index Wizard User Guide

Teradata Index Wizard
Release Number
English (United States)
Last Update
Product Category
Teradata Tools and Utilities

Additional Index Wizard Features

What-if analysis on a workload

Allows you to perform what-if analysis on a given workload. You can “play” with various aspects of the index information to tweak recommendations for greater performance. For more details, see “What-if Analysis” on page 91.

Schedule recommended indexes

Allows you to schedule a recommended set of indexes for a specific date and time. This feature works with Teradata Query Scheduler 6.2. For more details, see “Schedule Recommendation” on page 130.

Index Wizard can be started from other client programs

Teradata Index Wizard can be started from Teradata Visual Explain, Teradata Statistics Wizard. Teradata Index Wizard can also open these applications to help in your evaluation of recommended indexes. For more information, see “Working With Other Teradata Client Tools” on page 139.

Teradata System Emulation Tool can be used to help evaluate recommendations

The workload, along with the environment of the production system, can be imported to a test system using a separate tool called Teradata System Emulation Tool. For information about this tool, see “Teradata Analyst Pack” on page 18.

Data Demographics Window

Teradata Index Wizard provides a Data Demographics window that displays the demography details of selected tables. For more details, see Chapter 12: “Data Demographics.”

Execute SQL Window Option

Teradata Index Wizard has an option that enables you to create and execute SQL statements either through Teradata SQL Assistant or through an Execute SQL-Query window in Teradata Index Wizard. For more details, see “Executing SQL Feature” on page 137.