Question
What does index fill factor control when an index is built or rebuilt?
Select an option. Your answer will be checked instantly.
Correct Answer: A. The percentage of each leaf page initially filled with index data
Explanation:
Leaving free page space can reduce page splits for future inserts.
Too much free space, however, increases storage and read I/O.
Leave a Reply