Post reply

What are the difference between update statistics and execution plan in sql server

  • July 7, 2014 at 9:29 am

    #309755

    What are difference between update statistics and execution plan in sql server

  • July 7, 2014 at 9:32 am

    #1727453

    Errrr.... Asking for the similarities would result in a much shorter list, an empty one.

    Update statistics is a command which you can run to update the statistics which record data distribution.

    Execution plan shows the operators which were used to run a query

    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

  • July 7, 2014 at 9:42 am

    #1727459

    It might be more logical if we change some words in the question:

    What are the differences generated by update statistics on an execution plan in sql server?

    Answer: It depends. 😀

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • July 8, 2014 at 6:32 am

    #1727740

    What is it that you're actually looking for? Are you hitting a performance problem?

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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