Question

What Do You Mean By Fill Factor Concept With Respect To Indexes?

Answer 1

For any Index the most important property is Fill Factor. ... The default Fill Factor(100 or 0) will allow the SQL Server to fillthe leaf-level pages of an index with the maximum numbers of the rows it can fit. There will be no or very little empty space left in the page, when the fill factor is 100.