How to get estimated execution plan for stored procedure
How to get estimated execution plan for stored procedure ?
SET FMTONLY ON will give the plan.
Example
SET SHOWPLAN_ALL ON
GO
SET FMTONLY ON
GO
Exec Sample procedure
GO
SET FMTONLY OFF
GO
SET SHOWPLAN_ALL OFF
GO
No comments:
Post a Comment