Index Fragementation: Detections and Solutions

As data in table change, its indexes -pointers to such data- age out. The aging process is called index Fragmentation. To detect index fragmentation, query this DMV: dm_db_index_physical_stats. I recommend using this query. To fix fragmentation, you have multiple options. Here are two solutions: Reorganize index: This causes pages, not data in pages, to be reorganized. Simple[…]