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
Visit the DevX Tip Bank