FILLFACTOR

onconfig.std value

90

units

Percent

range of values

1 through 100

takes effect

When the index is built. Existing indexes are not changed. To use the new value, the indexes must be rebuilt.

refer to

Structure of B-Tree Index Pages

FILLFACTOR specifies the degree of index-page fullness. A low value provides room for growth in the index. A high value compacts the index. If an index is full (100 percent), any new inserts result in splitting nodes. You can also set the FILLFACTOR as an option on the CREATE INDEX statement. The setting on the CREATE INDEX statement overrides the ONCONFIG file value.