September 8, 2009 at 2:54 am
How and where to see the estimated query plan for a particular query in sql server 2005
September 8, 2009 at 2:57 am
Have a look here http://qa.sqlservercentral.com/articles/SQLServerCentral/66909/ , under "Saving the execution plan".
September 8, 2009 at 2:58 am
Highlight the query and click the 'Display estimated execution plan' button on the toolbar, or select 'Display estimated execution plan' from the query menu, or press Ctrl-L
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 8, 2009 at 2:58 am
In management studio use the Query menu option and it has options to show estimtated or actual execution plan. Shortcuts are Ctrl L and Ctrl M.
September 8, 2009 at 9:32 am
Funny enough, this video was just posted today:
http://www.sqlshare.com/showitem.aspx?id=BD9AAED9-6B7D-4979-ADD5-33436716CCAF
That will show you what the others have described.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply