MS SQL Server Indexes Question:
What is the Fillfactor concept in Indexes?
Answer:
The fill factor option is provided for smoothening index data storage and performance.
The percentage of space on each leaf level page to be filled with data is determined by the fill factor value When an index is created. This reserves a percentage of free space for future growth
The percentage of space on each leaf level page to be filled with data is determined by the fill factor value When an index is created. This reserves a percentage of free space for future growth
| Previous Question | Next Question |
| Explain the difference between clustered and non-clustered index? | How to maintain a fill factor in existing indexes? |