Index Maintenance

  • Jason Strate
  • Grant Fritchey


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 bloat. To prevent these issues, indexes must be maintained. If you do so, your database will remain a lean, mean querying machines.


Fill Factor Execution Plan Query Optimizer Query Plan Index Option 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Supplementary material (22 kb)
Performance Indexing - Chapter 09 - Index (zip 23 kb)

Copyright information

© Jason Strate and Grant Fritchey 2015

Authors and Affiliations

  • Jason Strate
    • 1
  • Grant Fritchey
    • 1
  1. 1.MNUS

Personalised recommendations