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.

utilities

onutil

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.

To modify the FILLFACTOR parameter dynamically, use the onutil SET command. Example:

% onutil
1> SET FILLFACTOR 60;