Reorganize all indexes in a Database in SQL Server.

Index Maintenance is one of the major task for a DBA. If rate of Index fragmentation increased then index de-fragmentation is become required. So we can use index reorganize option to rebuild all the indexes. Use Index reorganize option when rate of index fragmentation is b/w 10% to  40%.

Syntax:

Alter Index All On Table_Name Reorganize.

Example:

ALTER INDEX ALL ON geographicals Reorganize

GO

 

Rebuild Index for All tablex in database:

Exec sp_msforeachtable 'ALTER INDEX ALL ON ? Reorganize'

GO

Reference: