© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023
E. Pollack, J. StrateExpert Performance Indexing in Azure SQL and SQL Server 2022https://doi.org/10.1007/978-1-4842-9215-0_11

11. Index Maintenance

Edward Pollack1   and Jason Strate2
(1)
Albany, NY, USA
(2)
Hugo, MN, USA
 

Like anything in life, indexes require maintenance. Over time, the performance benefits of indexes can wane or, through data modifications, their sizes and the underlying statistics can drift and bloat. To prevent these issues, indexes must be maintained. Doing so will help ensure that a database will remain a lean, mean query-running machine!

With regard to maintenance, there are five areas to consider:

  • Index fragmentation

  • Heap bloat and forwarding ...

Get Expert Performance Indexing in Azure SQL and SQL Server 2022: Toward Faster Results and Lower Maintenance Both on Premises and in the Cloud now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial