I have an SP which is truncating a table and then insert into and selecting again. Now, I am planning to tune this SP. if I decide to view the estimated execution plan then is it a safe action or will it change any data, I know actual execution plan will change. Please let me know your thoughts.
Ok, I was able to generate the estimated plan, I see the plan is broken into multiple parts, that could be due to the code. However can we change it to display like a continuous flow. Broken plan does not make much sense. attached picture for your reference.
Also, the query cost steps in execution plan do not display much, is it like I have to generate actual plan for more information>?
sorry about attaching multiple images, I am unable to delete the extra image.