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 |
0 |
|
Range of values |
0–100 |
|
Status |
Dynamic |
|
Display level |
Intermediate |
|
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.
The amount of storage space used by your data – SAP ASE redistributes the data as it creates the clustered index.
Performance – splitting up pages uses SAP ASE resources.
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.