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 |