Indexes

Index Fragmentation in SQL Server (Reorganizing/Rebuilding Indexes)

1. Overview————SQL Server automatically maintains indexes whenever insert, delete, or update operations are performed on the underlying data. Though, in the cases where the underlying data contain very large volumes of information, the information in the indexes become scattered over time. This is known as Index Fragmentation. Index fragmentation can…