Tech Sathia
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
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)