The fill factor value determines the percentage of space on each page to be filled with data, reserving free space on each page for future table growth.

Fill-factor is always an integer valued from 1 to 100. The fill-factor option is designed for improving index performance and data storage.

********************************

In other words “fill factor value determines how much data is written to an index page when it is created / rebuilt.”

Advertisements