![GARRAY_FILL_FACTOR_PERCENT clarifications [CR 469543]](arrow-left.gif){kind=icon}
![LOAD TABLE syntax missing ON PARTIAL INPUT ROW [CR 469027]](arrow-right.gif){kind=icon}
This option was implemented in Sybase IQ 12.7 but not documented Corrections to the Sybase IQ Reference Manual will be available in the next GA release.
Specifies the percent of space on each HG garray pages to reserve for future incremental inserts. This space can be used for rows added to both new and 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 storage at the page level that can be allocated to new or existing groups when additional rows are inserted. Reserving space consumes additional disk space but can help the performance of incremental inserts into the HG index.
If future plans include incremental inserts into an HG index, and the new rows have values that are already present in the index, a nonzero value for the GARRAY_PAGE_SPLIT_PAD_PERCENT option may improve incremental insert performance.
If you do not plan to incrementally update the index, you can reduce this option to save disk space.
