http://blogs.msdn.com/b/chrissk/archive/2008/08/27/do-we-need-to-run-update-statistics-with-fullscan.aspxAuto-Update Statistics For a large majority of SQL Server installations, the most important best practice is to use auto create and auto update statistics database-wide. Auto create and auto update statistics are on by default. If you observe baden-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/chrissk/archive/2008/08/27/do-we-need-to-run-update-statistics-with-fullscan.aspx#10145771Fri, 25 Mar 2011 09:32:29 GMT91d46819-8472-40ad-a661-2c78acb4018c:10145771SQLZealot<p>Hi, Sometimes, Column statistics would be used for the query plan generation. If column stats are not being updated, then it may give you a wrong plan and cause a bad performance.</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10145771" width="1" height="1">