Which index should be rebuild or reorganized with MSSQL

Indexes are what allow to quickly retrieve and order data, instead of doing full table scans which take a very long time on large and very large tables. Indexes should be kept up to date. Microsoft SQL Server provides the tools for letting you know, when you should rebuilt and or reorganize your indexes.

Applies to:

  • Microsoft SQL Server 2005

Index rebuild and reorganize

  • In Microsoft SQL Server Management Studio , right clicking on the database, select Reports, Standard Reports, then select Index Physical Statistics
Index Physical Statistics
  • It will take a from a few seconds to almost a minute and you will get the following result.
Optimize Indexes
Results of the index analysis.
  • You can rebuild the indexes by right clicking on the table, select Indexes, then either select Rebuild and/or Reindex.
Rebuild Indexes
Select Rebuild or Reorganize indexes.