Is there any bad side affects to UPDATE stats.

[palbria]

Hello,
I am thinking of running update statistics on an sql database and I was wondering if there was anything that I should be aware of that might cause a problem. I am new at this (as you can tell) and I am a little reluctant to try it, but from everything that I have read it should be done. I ran the profiler and I see that one query is producing an error stating that one of the colums doesn't have statistics.

Thanks

[skhanal]

No and I hope not.

The optimizer will be able to create better execution plan with up to date statistics.

[MAK]

http://www.sql-server-performance.com/statistics.asp

from the link

But this option is not a panacea. When a SQL Server database is under very heavy load, sometimes the auto update statistics feature can update the statistics at inappropriate times, such as the busiest time of the day.