Queries Dragging? Try Defragging

Thursday Jun 21st 2007 by DatabaseJournal.com Staff
Share:

If your queries against a table or database are running slow, the indexes in that table might be fragmented. The cspDefragIndexes stored procedure can quickly and easily take care of the problem.

[From SQL Server Magazine]

Did you ever have a user tell you a query is taking a lot longer to compete than before, even though nothing in it has changed? If so, there's a good chance that the indexes in the table that the query ran against have become fragmented. Fixing this problem is a two-step process. First, you need to first determine which indexes have become fragmented. Second, you need to defrag those indexes.

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

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved