MS SQL Server Indexes Question:
Download Job Interview Questions and Answers PDF
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
Download SQL Server Indexes Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Explain the difference between clustered and non-clustered index? | How to maintain a fill factor in existing indexes? |