hello - i have bi-monthly maintenance plan that re-builds all the indexes of my databases where fragementation > 5%. my indexes are in good shape with this frequency.
However, with the re-build of indexes, my statistics only for those indexes are updated when the indexes are rebuilt. Also, i have auto-stats and create stats on [ default options ].
But my other statistics are not getting updated.
Is is a good idea to run sp_updatestats for all my user dbs after the rebuild index job completes.
This will make sure all my other stats that need a update will also be updated and since my re-indexing job will update stats for those indexes, sp_updatestats will not touch them since they have just been rebuilt by the rebuild index job.
So, basically, 2 steps:
1. Run rebuild index job for all Dbs for frag > 5%
2. Run sp_updatestats for all dbs.
please suggest on the approach,.