DBCC DBREINDEX and sp_updatestats

• Vik Nat

  Hall of Fame

  Points: 3930

  More actions

  October 3, 2003 at 4:22 pm

  #65236

  I have a quick question regarding reindexing, when I run DBCC DBREINDEX for a table, will the stats of that table be updated as well or will I need to update the stats after this? My understanding is that the Stats are updated for the table when we run DBREINDEX and that sp_updatestats do not need to be run seperately.

• 5409045121009-7368

  SSCoach

  Points: 15740

  More actions

  October 4, 2003 at 4:15 am

  #477082

  Similar question at http://dbforums.com/arch/179/2003/6/825836

• 5409045121009-7368

  SSCoach

  Points: 15740

  More actions

  October 4, 2003 at 4:23 am

  #477083

  Following confirms your understanding.

• 5409045121009-7368

  SSCoach

  Points: 15740

  More actions

  October 4, 2003 at 4:24 am

  #477084

  and finally the url

  http://www.sqlmag.com/Forums/messageview.cfm?catid=3&threadid=19497