Post reply

Does truncate table runs the update statistics also?

  • October 20, 2011 at 11:49 pm

    #261765

    Does truncate table runs the update statistics also?

    Thanks

  • October 21, 2011 at 12:11 am

    #1397743

    No. Also one more thing that the update statistics are not happening all on a sudden when its invalidated.

  • October 21, 2011 at 12:14 am

    #1397745

    Yaa...I have got..

    http://www.sql-server-performance.com/2007/gen-tips/

    Thanks

  • October 21, 2011 at 5:13 am

    #1397859

    No. The only thing that updates stats are index rebuilds, auto stats updates and UPDATE STATISTICS. However truncate, setting the rowcount to 0, will ensure that autoupdate gets triggered the next time the stats are needed.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply