Summary information |
|
|---|---|
Default value |
0 |
Range of values |
0–100 |
Status |
Dynamic |
Display level |
Intermediate |
Required role |
System Administrator |
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 at the time the index is created. As the data changes, the 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. For more information about the fill factor percentage, see create index in the Reference Manual.
