fill factor
Type: Basic
Default value: 0
The fill factor
option allows you to define the percentage of free space on a data page or an index page when you create an index or a table. The value can range from 1
to 100
. Setting the value to 80
would mean each page would be 80% full at the time of the create index
. SQL Server also allows you to specify the value of fill factor at the server level by providing a fill factor
parameter.
The following is an example of this option:
The following is a general recommendation of what to specify based on the different application types you are running:
• OLTP—This is a good candidate for leaving space free ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.