SQL Server 2022 Query Performance Tuning: Troubleshoot and Optimize Query Performance

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022

G. FritcheySQL Server 2022 Query Performance Tuninghttps://doi.org/10.1007/978-1-4842-8891-7_12

12. Dealing with Index Fragmentation

Grant Fritchey¹  

(1)

Grafton, MA, USA

 

As people work with the data in your databases, they make changes. They may be inserting new information, deleting information they no longer need, or modifying other information, or all of the above. As the data changes, these changes directly affect your indexes, both rowstore and columnstore, albeit in different ways. For your rowstore indexes, the acts of modifying the data can lead to page splits, pages getting rearranged, and pages getting emptied, all summed up in a term called fragmentation. ...