Example: Index Analysis and Repeated Parameters - 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-10-04
dita:mapPath
pon1628111750298.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
esx1472246586715
lifecycle
latest
Product Category
Teradata Vantageā„¢

If index analysis parameters are specified, they must not be repeated. If the parameters are repeated, an error is reported.

In the following example, the only index analysis parameter specified, IndexesPerTable, is specified once.

     INITIATE INDEX ANALYSIS ON table_1
     FOR MyWorkload
     IN MyQCD
     AS table_1Index
     SET IndexesPerTable = 2;

In the following example, the index analysis parameter IndexesPerTable is specified twice, so an error is returned.

     INITIATE INDEX ANALYSIS ON table_1
     FOR MyWorkload
     IN MyQCD
     AS table_1Index
     SET IndexesPerTable=2, ChangeRate=4, IndexesPerTable=4;

Result:

*** Failure 3706 Syntax error: Multiple "IndexesPerTable" options.

Note that the error is not caused by the discrepancy between the specified boundary conditions for the IndexesPerTable parameter: the same error would be reported if the boundary conditions matched in both specifications.