Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
CREATE INDEX statementUse the CREATE INDEX statement to create an index for one or more columns in a table, or on values returned by a UDR that uses column values as arguments.
FILLFACTOR OptionUse the FILLFACTOR option to specify the degree of index-page fullness when you want to create compacted indexes or provide information for the expansion of an index at a later date.

FILLFACTOR Option

Use the FILLFACTOR option to specify the degree of index-page fullness when you want to create compacted indexes or provide information for the expansion of an index at a later date.

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.

You cannot use the FILLFACTOR option on a forest of trees index.

FILLFACTOR Option


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 HCL OneDB™ Administrator's Guide.