Performing Analysis - Teradata Index Wizard

Teradata Index Wizard User Guide

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

Performing Analysis

After the workload is defined, it is analyzed and a new set of indexes is recommended. Teradata Index Wizard may also recommend that indexes be added or dropped to enhance system performance.

There are four types of analysis:

  • Index Analysis An index analysis is performed on a workload.
  • For more information, see “Performing an Index Analysis” on page 81.

  • Partition Analysis A partition analysis is performed on a workload
  • For more information, see “Performing a Partition Analysis” on page 87.

  • Restarting an Analysis If an Index analysis was interrupted, it can be restarted.
  • For more information, see “Restarting an Analysis” on page 89.

  • What-If Analysis This type of analysis allows you to check your own recommendations. on the workload to determine the performance benefits.
  • For more information, see “What-if Analysis” on page 91.

    For more information on the available input settings for an index analysis, see “Advanced Index Parameters” on page 83.