none
SQL Display estimated execution plan for update statement - does it actually do the update?

    Question

  • If I use the "Display Estimated Execution Plan" for a simple update statement, does it actually do the update?

    Just wanted to make sure I wasnt going crazy.

    Typically I am viewing the query plan that involve select statements, not updates.

    For some reason I got paranoid when I was looking at one and I noticed a status message that mentioned "...executing..."

    http://msdn.microsoft.com/en-us/library/ms178071%28v=sql.105%29.aspx

    Can somone reassure me that I am not going crazy?

    :)

    Tuesday, July 02, 2013 6:47 PM

Answers

  • It does not execute.   However I also do not like it displaying "Executing..." when trying to display the estimated exection plan.
    • Marked as answer by shiftbit Tuesday, July 02, 2013 10:48 PM
    Tuesday, July 02, 2013 9:05 PM

All replies

  • It does not execute.   However I also do not like it displaying "Executing..." when trying to display the estimated exection plan.
    • Marked as answer by shiftbit Tuesday, July 02, 2013 10:48 PM
    Tuesday, July 02, 2013 9:05 PM
  • It does not execute.   However I also do not like it displaying "Executing..." when trying to display the estimated exection plan.
    Well, technically it does execute, it's simply in a transaction and rolled back. 
    • Proposed as answer by jacky050327 Friday, July 05, 2013 2:15 AM
    Friday, July 05, 2013 2:08 AM
  • Well, technically it does execute, it's simply in a transaction and rolled back. 

    No. It is not executing. Estimated deals at relational engine level, not at the storage level. So it wont execute on the actual data.

    Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    Friday, July 05, 2013 5:21 AM