Is It Necessary to Update Statistics?

• dbaforever

  Hall of Fame

  Points: 3740

  More actions

  November 7, 2012 at 8:45 pm

  #265177

  My 2008 R2 database has Auto Create Statistics and Auto Update Statistics both set to TRUE.

  Is it necessary to also perform UPDATE STATISTICS on every table in my Maint Plan?

  Thanks, Bill

• November 8, 2012 at 12:08 am

  This was removed by the editor as SPAM

• November 8, 2012 at 12:14 am

  This was removed by the editor as SPAM

• dbaforever

  Hall of Fame

  Points: 3740

  More actions

  November 8, 2012 at 8:39 pm

  #1557432

  Stewart. thanks for your ideas and for the post about SS 2012 and its' new features for updating stats.

  My instance is 2008 so I'll probably leave the UPDATE STATISTICS in my maint. plan, just to be sure they are nice and tidy.

  Bill in the USA