Integer
66
Purpose
The IndexLoadFactor parameter specifies the percentage of entries that are retained when an index block becomes full and is split. A value of 95 means that 95 percent of entries are retained in the current block and 5 percent of entries are moved to a new block.
Statistically, a 66 percent load factor provides optimal loading when entries are added in random key order and a higher load factor (for example, 95 percent) provides better loading when entries are added in sequential key order.
The minimum parameter value is 50 percent, and the maximum parameter value is 95 percent.
Parameter is read when …
The database server node is initialized; for example, when you restart the database server.