Advertisement

Index Maintenance

  • Jason Strate
  • Grant Fritchey

Abstract

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.

Keywords

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

978-1-4842-1118-2_9_MOESM1_ESM.zip (22 kb)
Performance Indexing - Chapter 09 - Index Maintenance.zip (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