After the workload is defined, it is analyzed and a new set of indexes is recommended. Teradata Index Wizard may also recommend that indexes be added or dropped to enhance system performance.
There are four types of analysis:
For more information, see “Performing an Index Analysis” on page 81.
For more information, see “Performing a Partition Analysis” on page 87.
For more information, see “Restarting an Analysis” on page 89.
For more information, see “What-if Analysis” on page 91.
For more information on the available input settings for an index analysis, see “Advanced Index Parameters” on page 83.
After analyzing the index, reports provide data that enables you to make a decision about the index recommendation. See Reports.