Example: Index Analysis and Repeated Parameters - Advanced SQL Engine - Teradata Database

SQL Data Manipulation Language
Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
ft:locale
en-US
ft:lastEdition
2021-07-27
dita:mapPath
vjt1596846980081.ditamap
dita:ditavalPath
vjt1596846980081.ditaval
dita:id
B035-1146
lifecycle
previous
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;      *** 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.