Blog / Blog Article: Don’t Forget to Maintain Your Indexes

Don’t Forget to Maintain Your Indexes

Indexing | August 8, 2009 | 3:22 am

So long as data is inserted, updated and deleted from tables, indexes will become fragmented over time, and performance will suffer. Index maintenance is vital to keeping databases and their users happy. In this article, I go through the key index maintenance tasks and identify more essential areas that are a DBA’s duty to maintain. Read more…

Share and Enjoy:
  • Print
  • Digg
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • FriendFeed
  • LinkedIn
  • Reddit
  • Slashdot
  • Technorati
  • Twitter
Related posts:
  1. Don’t Make Dumb Mistakes by Duplicating Indexes
  2. Brad’s Sure Guide to Indexes
  3. Reasons Why You May Not Want to Use a Heap
  4. The Maintenance Plan Wizard Can Lead You Astray
  5. Ola Hallengren Updates Free Database Maintenance Scripts to Support SQLBackup 6.3
Copyright 2009-2010 Brad M McGehee