Evaluation of the ChangeRate Variable by INITIATE INDEX ANALYSIS - Advanced SQL Engine - Teradata Database

SQL Data Manipulation Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
qtb1554762060450.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata Vantage™

The following table indicates the method INITIATE INDEX ANALYSIS uses to evaluate column change rate values for index recommendation. Only those columns with a change rate rank ≤  the specified change rate rank are considered for recommendation as an index or composite index component. If no change rate is specified, the default value is 5.

Change Rate Rank Description Percentage of Updates on Column
0 No updates on the column. 0
1 1 update per 1,000,000 selects on the table. .0001
2 1 update per 100,000 selects on the table. .001
3 1 update per 10,000 selects on the table. .01
4 1 update per 1,000 selects on the table. .1
5 1 update per 100 selects on the table. 1
6 5 updates per 100 selects on the table. 5
7 10 updates per 100 selects on the table. 10
8 25 updates per 100 selects on the table. 25
9 More than 25 updates per 100 selects on the table. >25