I’ve created a Maintenance job using the Database Maintenance Plan Wizard that reorganizes data and index pages.
It has been scheduled to run on a weekly basis.
Now, I want to create another Maintenance job in order to “Update Statistics used by query optimizer”.
When this “Update Statistics used by query optimizer” job should run? Should it be scheduled to run just after the rebuilding indexed job?
Or can it be scheduled to run the day after? Would it be OK to set the “Sample” option for the update statistics job to 100%?
And this job, is it the same as running sp_updatestats?