INITIATE INDEX ANALYSIS | SQL Statements | Teradata Vantage - INITIATE INDEX ANALYSIS - Analytics Database - Teradata Vantage

SQL Data Manipulation Language

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-12-13
dita:mapPath
pon1628111750298.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
esx1472246586715
lifecycle
latest
Product Category
Teradata Vantage™

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:

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
  • INSERT
  • SELECT
IndexRecommendations
INSERT
  • AnalysisStmts
  • IndexMaintenance
  • IndexColumns
  • JoinIndexColumns

If you specify a checkpoint trigger, you must have both INSERT and DELETE privileges on the AnalysisLog table in QCD_name.