Rebuild Only the Indexes that Need Help

Friday Jul 4th 2008 by DatabaseJournal.com Staff

Don’t give in to the temptation of rebuilding your indexes at the first evidence of fragmentation. Instead, use the rebuild_indexes_by_db stored procedure to tackle only the indexes that actually need help.

[From SQL Server Magazine]

A common misconception among SQL Server DBAs is that they need to rebuild their indexes often—even as often as every night. The theory is that, to be effective, indexes can’t have any fragmentation. Another common misconception about indexes is that if you don’t rebuild them frequently, they’ll become corrupted, and then you’re in a HEAP of trouble. (Apologies for the pun.)

The article continues at http://www.sqlmag.com/Articles/Index.cfm?ArticleID=99019

Mobile Site | Full Site