Post reply

Effect of adding update statistics as part of the stored procedure

  • September 13, 2012 at 3:32 am

    #261791

    Hi,

    What are the negative effects of running update statistics on few tables as part of stored procedure that has application logic?

    Thanks.

  • September 13, 2012 at 3:35 am

    #1537094

    It takes some time to update statistics....

    What are you doing exactly in your stored proc?

    It can be well justified if it does modify big chunk of a table.

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

  • September 13, 2012 at 3:40 am

    #1537097

    It takes time and it causes a recompile of the rest of the procedure and any other plans that use the statistics.

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

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