Index Maintenance – Fragmentation should not be your only concern

Index fragmentation is not the only consideration when constructing an index maintenance plan. This article will look at other considerations that should be taken into account such as: Page fullness FILLFACTOR and PAD_INDEX The impact of Snapshot Isolation The less fragmented an index is, the more performant it will be. Inserting records inside an index…

2