devxlogo

Rebuild All Database Indexes

Rebuild All Database Indexes

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

devx-admin

Share the Post: