Chapter 9 Recommendations - 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

Index Wizard has an execute recommendation feature that allows you to execute index recommendations immediately or schedule them for a later time. This feature works in conjunction with Teradata Dynamic Query Manager (Teradata DQM) to schedule the execution of recommendations.

Executing a recommendation applies the index recommendations to the production database. It is highly recommended that index recommendations be validated before executing. For more information, see Chapter 8: “Validation.”

The following topics are covered in this section:

  • Executing a Recommendation Immediately
  • Schedule Recommendation
  • Schedule Recommendation Errors