CODEWITHSUNDEEP
sql-server-2008sql-server-2008-r2
GibboK
GibboK

Reputation: 73918

Reorganize and Rebuild Indexes automatically

I'm using MS SQL 2008 R2, I would like to know if there is any features in the database that allows the rebuilding of all Indexes in all the Tables for a specify database at a specific interval for example one rebuilding every week.

Please let me know thanks!

Upvotes: 5

Views: 6728

Answers (1)

Martin Smith
Martin Smith

Reputation: 453278

Maintenance plans.

But you're better off not using these and using something that rebuilds according to need (fragmentation levels) more intelligently such as Ola Hallengren's SQL Server Index and Statistics Maintenance script

Upvotes: 3

Related Questions