SQL Server Performance Forum – Threads Archive
AUTO CREATE/UPDATE STATISTICS considerationsIf 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?
SQL-Server-Performance.com All in Love is Fair
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
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).