I want to rebuild my indexes and statistics on DB.
How can I select this option on production maintenance.
SQL Server Version : Microsoft SQL Server 2012 - 11.0.2100.60 (X64) (Build 7601: Service Pack 1)
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
I would prefer to rebuild the indexes where the fragmentation percent of the indexes is greater than 30% and a Re-org of indexes where fragmentation percent is in between 9% and 30%.
Coming to update stats, I would prefer to do it with Full Scan depending on the size of the databases.
While these are resource intensive database operations, I would prefer to do these operations over the weekends or after business hours.
For Production Environments, I would usually setup jobs and allow them to run over the weekend.
Please go through the below link for maintenance plans(very useful) and customize accordingly to your environment.