Performing Analysis - Teradata Index Wizard

Teradata Index Wizard User Guide

Product
Teradata Index Wizard
Release Number
15.00
Language
English (United States)
Last Update
2018-09-28
dita:id
B035-2506
lifecycle
previous
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.