Home
Schema - Do you use FillFactor of 90% for indexes and constraints?
  v3.0 Posted at 3/12/2019 2:51 PM by Christian Morford-Waite

​​​Indexes should generally have a fillfactor of 90%. If the amount of data stored in the database does not prohibit rebuilding indexes, a fillfactor of 90% should be maintained to increase the performance of inserts.​

​A table that expects a lot of insert operations could use a lower fillfactor.​​

Related rules

    Do you feel this rule needs an update?

    If you want to be notified when this rule is updated, please enter your email address:

    Comments: