15.00 - 15.10 - Teradata Index Wizard - Teradata Database

Teradata Database Introduction to Teradata

Product
Teradata Database
Release Number
15.00
15.10
Content Type
User Guide
Publication ID
B035-1091-151K
Language
English (United States)
Last Update
2018-09-25

Teradata Index Wizard analyzes SQL queries and suggests candidate indexes to enhance their performance.

The workload definitions, supporting statistical and demographic data, and index recommendations are stored in various QCD tables.

Using data from a QCD or the Database Query Log (DBQL), Teradata Index Wizard:

  • Recommends, using an INITIATE PARTITION ANALYSIS statement, the potential performance benefits from adding a partitioning expression to one or more tables in a given workload.
  • The statement does not recommend the complete removal of any defined partitioning expressions. It considers, however, the alteration of an existing partitioning expression if a Partitioned Primary Index (PPI) table is explicitly included in the table_list.

  • Recommends secondary indexes for the tables based on workload details, including data demographics, that are captured using the QCF.
  • Enables you to validate index recommendations before implementing the new indexes.
  • Enables you to perform what-if analysis on the workload. Teradata Index Wizard allows you to determine whether your recommendations actually improve query performance.
  • Interfaces with other Teradata Tools and Utilities, such as Teradata SET to perform offline query analysis by importing the workload of a production system to a test system
  • Uses Teradata Visual Explain and Compare tools to provide a comparison of the query plans with and without the index recommendations.
  • Teradata Index Wizard can be started from Teradata Visual Explain and Teradata SET. Teradata Index Wizard can also open these applications to help in your evaluation of recommended indexes.