This statement is only supported on the Block File System on the primary cluster. It is not available for the Object File System.
Analyzes a query workload and generates a set of recommended secondary and single-table join indexes for optimizing its processing.
INSERT EXPLAIN and INITIATE PARTITION ANALYSIS are supported only on the Block File System on the primary cluster, not the Object File System.
Also see the following sections:
ANSI Compliance
INITIATE INDEX ANALYSIS is a Teradata extension to the ANSI SQL:2011 standard.
Required Privileges
The privileges required to submit an INITIATE INDEX ANALYSIS request are the following:
Privilege Required | Table Set in Database QCD_name |
---|---|
|
IndexRecommendations |
INSERT |
|
If you specify a checkpoint trigger, you must have both INSERT and DELETE privileges on the AnalysisLog table in QCD_name.