Can I read Understanding SQL Server Fill Factor on EtoBox?
Understanding SQL Server Fill Factor is a document available to read on EtoBox.
What is Understanding SQL Server Fill Factor about?
The fill factor specifies how full SQL Server should make the leaf level pages of an index during creation. It is useful when creating a new index on an existing table with predictable future changes. A properly chosen fill factor value yields better update performance than the default by reducing page splits required as the index fills. The default fill factor of 80% is usually efficient, but an explicit setting only applies at index creation - SQL Server does not dynamically maintain a certain percentage
- Language
- EN