dcsimg
 

Rebuild All Database Indexes

Monday May 6th 2019 by Hannes Du Preez

Language: SQL, Expertise: Intermediate - See how to rebuild all of the indexes in your database with this query.

You can rebuild all indexes present in your database with the following query:

EXEC sp_MSforeachtable @command1="print '?' DBCC DBREINDEX ('?', ' ', 80)" 

GO 

EXEC sp_updatestats 

GO
Home
Mobile Site | Full Site