default fill factor percent

default fill factor percent determines how full SAP ASE makes each index page when it is creating a new index on existing data, unless the fill factor is specified in the create index statement.

Summary Information

Default value


Range of values




Display level


Required role

System administrator

Configuration group

SQL Server Administration

The fillfactor percentage is relevant only when the index is created. As data changes, pages are not maintained at any particular level of fullness.

default fill factor percent affects:

There is seldom a reason to change default fill factor percent, especially since you can override it in the create index command. See create index in the Reference Manual: Commands.