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” on page 123.Chapter 8: “Validation.”
After validating an index recommendation, you execute the recommendation. See Executing Recommendations.