Databases · Senior · Question 54 of 75

What does the `fillfactor` storage setting do for a heavily updated table?

1Fills empty columns with default values
2Limits how many rows a table can contain
✓Correct answer: Leaves free space in each page so updated row versions can stay on the same page (enabling HOT updates)

Explanation

A fillfactor of, say, 80 trades some space for fewer index updates and less bloat on update-heavy tables.

Further reading

Test yourself

Take the Databases · Senior quiz: questions and options are shuffled, and you get a review of your mistakes at the end.