Subject | Plan in a non selectable stored procedure |
---|---|
Author | Aldo Caruso |
Post date | 2015-08-17T14:11:37Z |
Hello,
I noticed that the plan a stored procedure uses can be inspected if
it is a selectable stored procedure, whereas if it is a stored procedure
that is not selectable (i.e. it contains no suspend clause ) its plan
cannot be inspected.
Is there a way to inspect the plan in that case ?
Thanks,
Aldo
I noticed that the plan a stored procedure uses can be inspected if
it is a selectable stored procedure, whereas if it is a stored procedure
that is not selectable (i.e. it contains no suspend clause ) its plan
cannot be inspected.
Is there a way to inspect the plan in that case ?
Thanks,
Aldo