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 |