Explain the 'Fill factor' concept in Indexes.- 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.
- This option is provided for fine tuning index data storage and performance.
- The fill factor value is a percentage from 1 to 100 and the server-wide default is 0 which means that the leaf-level pages are filled to capacity.