Indexing is one of the most powerful tuning options available to a database designer or database administrator (DBA). Traditionally, index selection has been a complex and manual process requiring the DBA to have detailed knowledge of the application workloads and data demography of your Teradata, as well as experience and understanding of parallel query plan optimization. As more application workloads are introduced, analyzing the impact and derived benefit of an index becomes increasingly difficult. To determine a good set of indexes, designers had to rely on their application experience and intuition.
Teradata Index Wizard takes the guesswork out of indexing. Teradata Index Wizard automates index selection and creates statistical information that allows DBAs to make a fully informed index choice.
To learn more, see How Teradata Index Wizard Works.