Specifies the amount of space to reserve for an HG index.
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 identical values). Reserving space consumes some disk space but can help the performance of incremental inserts into the HG index and reduce fragmentation.
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 helps.
