Analyzes a query workload and generates a set of recommended secondary and single-table join indexes for optimizing its processing.
For more information about QCDs and index analysis, see:
- COLLECT DEMOGRAPHICS
- COLLECT STATISTICS (QCD Form)
- INITIATE PARTITION ANALYSIS
- RESTART INDEX ANALYSIS
- INSERT EXPLAIN
- “CREATE TABLE (Index Definition Clause)” in Teradata Vantage™ - SQL Data Definition Language Detailed Topics , B035-1184
- Teradata Vantage™ - SQL Request and Transaction Processing, B035-1142
- Teradata Vantage™ - Database Design, B035-1094
- Teradata® Index Wizard User Guide, B035-2506
Required Privileges
The privileges required to submit an INITIATE INDEX ANALYSIS request are the following:
| Privilege Required | Table Set in Database QCD_name |
|---|---|
and
|
IndexRecommendations |
| INSERT |
|
If you specify a checkpoint trigger, you must have both INSERT and DELETE privileges on the AnalysisLog table in QCD_name.
ANSI Compliance
INITIATE INDEX ANALYSIS is a Teradata extension to the ANSI SQL:2011 standard.