CODEWITHSUNDEEP
sql-server
Aarsh Thakur
Aarsh Thakur

Reputation: 607

How can I see the execution plan for stored procedures and triggers in SQL Server?

How can I see the execution plan for stored procedures and triggers in SQL Server?

Upvotes: 2

Views: 3475

Answers (3)

SQLMenace
SQLMenace

Reputation: 135011

you can do

set showplan_text on

or hit CTRL + K and it will be included as a separate tab next to query results

Upvotes: 2

SqlACID
SqlACID

Reputation: 4014

Assuming you're using MSSQL, yes, see here

Upvotes: 1

Mitch Wheat
Mitch Wheat

Reputation: 300559

Yes, you can using SQL Profiler. See Using SQL Server Profiler

Upvotes: 2

Related Questions