Posted in February 2011

Index fill factor and page splits

We all know that Indexes have an option of specifying fill-factor. By fill-factor we mean that we can specify how much of that page to be filled up with data. By specifying a fill-factor of 80 %, we intend to free 20 % of the space for future additions to the tables. Why do we … Continue reading