Thursday, March 3, 2016

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