Evaluation of the ChangeRate Variable by INITIATE INDEX ANALYSIS - Teradata Database - Teradata Vantage NewSQL Engine

SQL Data Manipulation Language

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
fbo1512081269404.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.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