AUTO CREATE/UPDATE STATISTICS considerations | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

AUTO CREATE/UPDATE STATISTICS considerations

If I use AUTO CREATE STATISTICS and AUTO UPDATE STATISTICS, do I have to keep on concerning about the statistics or is it enough with this? If I have to worry about statistics, what kind of issues should I take into consideration?
When these two options are enabled, then sql server will automatically determine and update those statistics.
If your db goes into many frequent insert,delete than you can run manual statistics updatation.
Are you asking for 2005?
Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided “AS IS” with no warranties for accuracy.
Even though they are ON on the database, it is ideal to run them intermittently during less traffic hours to get the optimization levels back. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
thank you all, and yes I aks for sql server 2005.
Don’t rely on auto-update stats. It’s frequently not good enough. I’d advise to run manual update stats as often as you can (preferably nightly).
]]>