Specifies the amount of space to reserve for an HG index.
0 to 1000
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.
25
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 it 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 will have values that are already present in the index, a non-zero value for this option will help.