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.