Schema - Do you use FillFactor of 90% for indexes and constraints?

Last updated by SSW.Rules.SharePointExtractor about 4 years ago.See history

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.


Adam Cogan
We open source.Loving SSW Rules? Star us on GitHub. Star
Stand by... we're migrating this site to TinaCMS