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..."
Can somone reassure me that I am not going crazy?
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
Well, technically it does execute, it's simply in a transaction and rolled back.
Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.