Rebuild indexes online with SQL Server 2005

Monday Dec 10th 2007 by DatabaseJournal.com Staff
Share:

The ability to rebuild indexes in SQL Server 2005 is a fantastic new option.

[From TechRepublic]

Indexes are specialized data structures that operate on tables (and sometimes views) in the database engine used to aid in the searching for and sorting of data. Indexes are vital to the database engine returning results quickly. As data is modified in the underlying tables that the indexes operate on, the indexes become fragmented. Fragmentation is when the logical ordering of an index does not match the physical ordering of the underlying table or view. As the indexes become more and more fragmented, query times can begin to suffer. The remedy to this situation is to either reorganize or rebuild the index in SQL Server 2005.

The article continues at http://blogs.techrepublic.com.com/datacenter/?p=249

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