1 vote

How can I see the plan for ONE statement in a stored procedure?

There IS a way. In SSMS set Include Actual Exec Plan (Ctrl-M) SET STATISTICS XML OFF; in first statement of batch Wrap the statement in question like: SET STATISTICS XML ON; statement(s) SET ...
Masaka's user avatar
  • 11

Only top scored, non community-wiki answers of a minimum length are eligible