MS SQL Server Indexes Interview Question:

What is the Fillfactor concept in Indexes?

Submitted by: Administrator

The fill factor option is provided for smoothening index data storage and performance.

The percentage of space on each leaf level page to be filled with data is determined by the fill factor value When an index is created. This reserves a percentage of free space for future growth
Submitted by: Administrator