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

Teradata Vantage™ - SQL Data Manipulation Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1146-175K
Language
English (United States)

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