No (in general - need to set in query)
Table-Gathering statistics for a table,will touch its indexes also ?or need to do it seperatly.
Yes (in your case)
Last edited by dbasan; 06-05-2007 at 10:50 AM.
I pointed out out frequency beacuse, if you run gather stats job weekly once and still face performance problems and after analyzing it seemsexplain plan is not good enough because of volume of data updated or inserted, then you need to gather stats more than once a week.
Hope this clarifies.
are you changing more than 20% of your data a week?
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Click Here to Expand Forum to Full Width