Validating an Index - Teradata Index Wizard

Teradata Index Wizard User Guide

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

Validating an Index

Teradata Index Wizard validates index recommendations on a production system without actually updating the production table index. This feature is optional, but highly recommended because it ensures the index recommendation will help database performance before actually adding the indexes.

The execution plans obtained with the recommendation can be compared with the original query plans (those without the index recommendations) using Teradata Visual Explain’s Compare feature. Teradata Index Wizard interfaces with Teradata Visual Explain in providing a query-by-query compare.

For information on validation, see Chapter 8: “Validation.”