Specifies the percent of space on each HG garray pages to reserve for future incremental inserts into existing groups. The garray tries to pad out each group to include a pad of empty space set by the value.This space is used for rows added to existing index groups.
0 – 1000
25
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.
An HG index can reserve some storage on a per-group basis (where group is defined as a group of rows with equivalent values). Reserving space consumes additional disk space but can help the performance of incremental inserts into the HG index.
If you plan to do future incremental inserts into an HG index, and those new rows have values that are already present in the index, a nonzero value for this option might improve incremental insert performance.
If you do not plan to incrementally update the index, you can reduce the values of this option to save disk space.
“GARRAY_PAGE_SPLIT_PAD_PERCENT option”
“sp_iqindexfragmentation procedure,” Chapter 7, “System Procedures,” in Reference: Building Blocks, Tables, and Procedures
