Hi All,
How can I tell/prove, whenever I run a stored proc or an ad-hoc sql statement in SSMS query window, whether SQL has reused the plan from plan-cache or a new plan got generated. Can this info be obtained from actual execution or is there an alternative way to find this information out?
Thanks,
Sam