Post reply

Benefit of updating statistics after creating new index

  • June 10, 2017 at 4:35 pm

    #343227

    Is there any performance benefit of updating statistics after creating a new index?  I am in the process of creating up to 40 new indexes to improve performance in my database and curious to know if I should update the statistics on each of the affected tables afterward.

  • June 11, 2017 at 5:09 am

    #1946330

    No, the stats are going to be up to date because you just created the index.

    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 2 posts - 1 through 1 (of 1 total)

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