Interview Questions
1. What is Fill factor in indexes?
Data is stored in the leaf-level pages of Index. The percentage of space to be filled with data in a leaf level page is decided by
fill factor. The remaining space left is used for future growth of data in the page. Fill factor is a number from 1 to 100. Its default
value is 0, which is same as 100. So when we say fill factor is 70 means, 70% of space is filled with data and remaining 30% is
vacant for future use. So higher the fill factor, more data is stored in the page. Fill factor setting is applied when we create/rebuild
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