Rules for Performing 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
Language
English (United States)
Last Update
2024-04-05
dita:mapPath
pon1628111750298.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
esx1472246586715
lifecycle
latest
Product Category
Teradata Vantage™
The following set of rules applies to INITIATE INDEX ANALYSIS:
  • The analysis accepts any of the following DML statements as valid workload components:
    • DELETE
    • INSERT
    • MERGE
    • SELECT
    • UPDATE
  • The specified QCD database must exist in the system. Otherwise, the request aborts and the system returns an error.
  • The specified workload must exist in the specified QCD_name database. Otherwise, the request aborts and the system returns an error.
  • If you specify a table list, then only that list of tables is considered for index analysis.

    If the workload does not contain any tables that match at least one table in the table list, then an error is reported. Otherwise, only the matching list of tables is considered for index analysis.

  • A maximum of 1,024 tables can be analyzed per workload.
  • No error is reported if the same table is specified more than once for index analysis.
  • The index analysis parameters must not be repeated.

    If they are repeated, or if a value is out of range for a parameter, then the request aborts and the system returns an error.

  • If the session is logged off or restarted while INITIATE INDEX ANALYSIS is being performed and no checkpoint is specified, then no index recommendations are saved.

    You must perform the INITIATE INDEX ANALYSIS request again in the restarted session to create the index recommendations.