BTREE_PAGE_SPLIT_PAD_PERCENT Option

Determines per-page fill factor during page splits for B-Tree structures.

Allowed Values

0 – 90

Default

50

Scope

DBA permissions are not required to set this option. Can be set temporary for an individual connection or for the PUBLIC group. Takes effect immediately.

Description

B-Tree structures are used by the HG, LF, DT, TIME, and DTTM indexes. Splits of a B-Tree page try to leave the specified percentage empty to avoid splitting when new keys are inserted into the index.

Indexes reserve storage at the page level that can be allocated to new keys as additional data is inserted. Reserving space consumes additional disk space, but can help the performance of incremental inserts. If future plans include incremental inserts, and the new rows do not have values that are already present in the index, a nonzero value for GARRAY_PAGE_SPLIT_PAD_PERCENT may improve incremental insert performance.

If you do not plan to incrementally update the index, you can reduce the value of this option to save disk space.

Related reference
GARRAY_FILL_FACTOR_PERCENT Option
GARRAY_PAGE_SPLIT_PAD_PERCENT Option