Execution Plan

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

j nuñez SSCrazy Points: 2175 More actions · Answer 1

If yoy are working with Microsoft Sql Server Management Studio:

- Open a new query window (Ctrl+N)

- Select "Include Actual Execution Plan" (Ctrl+M)

- Run your Query (F5) and examine your execution plan as a new folder close to Results and Messages.

jvamvas Say Hey Kid Points: 708 More actions · Answer 2

You can also view them in Profiler .

When you set up a new trace ,

Go to the Events Selection Tab , Expand the performance tab , check ShowPlanXML

http://www.ITjobfeed.com

Satya(SQLMaster) SSC Eights! Points: 872 More actions · Answer 3

If you want to see without executing the script the you can use Display Execution plan as per this http://msdn.microsoft.com/en-us/library/ms178071.aspx link.

-Satya SK Jayanty
SQL Server MVP (Follow me @sqlmaster)
Author of SQL Server 2008 R2 Administration CookBook
SQL Server Knowledge Sharing network

spaghettidba SSC Guru Points: 105732 More actions · Answer 4

Ctrl + L if you just want the estimated execution plan

-- Gianluca Sartori