SQL SERVER: 4 Possible Methods to Resolve Index Fragmentation

added by lionofdezert
1/11/2011 12:47:47 PM

0 Kicks, 42 Views

For OLTP databases, index fragmentation is a major problem for query performance. We have four methods to resolve this fragmentation problem. Let’s explore benefits and drawbacks of these methods one by one. So can choose best one according to our requirments.