Interview Questions
1. What is a Fill Factor?
The fill-factor option is provided for fine-tuning index data storage and performance. When an index is created or rebuilt, the fill-factor value determines the percentage of space on each leaf-level page to be filled with data, reserving the remainder on each page as free space for future growth.
For example, specifying a fill-factor value of 80 means that 20 percent of each leaf-level page will be left empty, providing
space for index expansion as data is added to the underlying table. The empty space is reserved between the index rows
rather than at the end of the index.
Submit an interview question
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment