Summary information |
|
|---|---|
Default value |
0 |
Range of values |
0–100 |
Status |
Dynamic |
Display level |
Intermediate |
Required role |
System administrator |
Configuration group |
SQL Server Administration |
default fill factor percent determines how full Adaptive Server 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. 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:
The amount of storage space used by your data – Adaptive Server redistributes the data as it creates the clustered index.
Performance – splitting up pages uses Adaptive Server 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.
