Evaluation of the ChangeRate Variable by INITIATE INDEX ANALYSIS - 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™

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