sqlbuddy123 (4/3/2014)
Robin35 (4/3/2014)
Our maintenance are scheduled to run every sunday around 5 AMThanks
Is it possible to run index reorg & update stats on nightly basis and rebuilds during the weekend ? May be it can have some better performance improvement.
--
SQLBuddy
Thank you very much .....
We thought of doing that, but we recognized an index which was created a week back and it is the culprit. After we dropped the newly created index the performance is good.
I appreciate everyone for your help.
Thanks