FILLFACTOR Option

Enterprise Edition Home | Express Edition Home | Previous Page | Next Page SQL Statements > CREATE INDEX >

FILLFACTOR Option

The FILLFACTOR option takes effect only in the following cases:

when you build an index on a table that contains more than 5,000 rows and that uses more than 100 table pages
when you create an index on a fragmented table
when you create a fragmented index on a nonfragmented table.

Use the FILLFACTOR option to provide for expansion of an index at a later date or to create compacted indexes.

FILLFACTOR Option:
 
|--FILLFACTOR--percent------------------------------------------|

Element	Description	Restrictions	Syntax
percent	Percentage of each index page that is filled by index data when the index is created. The default is `90.`	1 ≤ percent ≤`100`	Literal Number

When the index is created, the database server initially fills only that percentage of the nodes specified with the FILLFACTOR value.

The FILLFACTOR can also be set as a parameter in the ONCONFIG file. The FILLFACTOR clause on the CREATE INDEX statement overrides the setting in the ONCONFIG file. For more information about the ONCONFIG file and the parameters you can use, see your IBM Informix Administrator's Guide.