difference between sp_updatestats and update_statistics(when to use sp_updatestats and update_statistics)

• best_yunus

  SSC-Addicted

  Points: 409

  More actions

  November 20, 2013 at 3:34 am

  #301558

  Hi Experts,

  What is the difference between sp_updatestats and update_statistics.

  When we have to use sp_updatestats and when to use update_statistics?

• Veteran Jones

  SSC Eights!

  Points: 937

  More actions

  November 20, 2013 at 6:34 am

  #1667777

  I believe the sp executes update statistics.

• RTaylor2208

  SSChampion

  Points: 13298

  More actions

  November 20, 2013 at 6:51 am

  #1667783

  sp_updatestats will update the statistics for all user defined and internal tables with the database you execute the procedure for.

  http://technet.microsoft.com/en-us/library/ms173804.aspx

  UPDATE STATISTICS is used when you only want to update the stats for a particular table \ index and is much more configurable:

  http://technet.microsoft.com/en-us/library/ms187348.aspx

  MCITP SQL 2005, MCSA SQL 2012

• best_yunus

  SSC-Addicted

  Points: 409

  More actions

  November 26, 2013 at 7:04 am

  #1669135

  THanks :smooooth: