Geek asks and answers

Reorganize and rebuild indexes automatically

I am using MS SQL 2008 R2, I would like to know if there are any functions in the database that allow you to rebuild all the indexes in all tables for a database named a certain interval , for example, one rebuild every week.

Please let me know thanks!

+5
source share
1 answer

Maintenance plans.

But you better not use them and use something that reorganizes according to your needs (fragmentation levels) more intelligently, for example Ola Hallengren SQL Server Index and Statistics Maintenance script

+3
source

More articles:


All Articles