Defragging SQL Indexes

added by resabio
12/13/2011 8:37:23 PM

0 Kicks, 108 Views

Similar to hard drives, each time data in a SQL index is added, deleted, or updated, the index has the potential to become fragmented. The ultimate result is that SQL queries will take a less than optimal time to execute. Just as defragging a hard drive can improve performance, defragging SQL Server indexes can improve performance significantly.