Defragging SQL Indexes

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.