Product Information > JADE Developer’s Reference > Chapter 4 - Collections Behavior and Tuning > Tuning the Btree Load Factor

Tuning the Btree Load Factor

The load factor specifies the ratio of entries (as a percentage factor) that are moved to a new block when a Btree block splits.

Statistically, a 66 percent load factor provides optimal loading when entries are added in random key order whereas a higher load factor value (for example, 95 percent) provides a denser loading of blocks when entries are added in sequential key order.