2016 | OriginalPaper | Chapter
6. Index Fragmentation
Published in:
Pro SQL Server Internals
Abstract
Index fragmentation is, perhaps, one of those rare topics that does not entirely belong to the “It Depends” category. Most database professionals agree that fragmentation negatively affects the system. While that is correct, it is still important to understand the downside of index fragmentation and analyze how your system is affected by it.