Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-12-12 : 07:35:35
|
| Pankaj writes "Hi,Please help me in finding Execution Plan Window. I have just installed Microsoft Visual Studio 2005. I can view Stored Procedure and execute from Server Explorer window, but I am not able to see the execution plan. Do I require any more thing to install." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-12-12 : 07:36:11
|
| You can view the query execution plan in SQL Server Management Studio or Query Analyzer, but not in Visual Studio. |
 |
|
|
monty
Posting Yak Master
130 Posts |
Posted - 2006-12-12 : 23:20:38
|
| Use the Transact-SQL Query Editor,thenWhen Query Editor is open, the SQL Query toolbar appears with the button:Display Estimated Execution PlanRequests a query execution plan from the query processor without actually executing the query, and displays the plan in the Execution plan window. This plan uses index statistics as an estimate of the number of rows expected to be returned during each portion of the query execution. The actual query plan used can be different from the estimated execution plan, if the number of rows returned is significantly different from the estimate, and the query processor changes the plan to be more efficient.or do the following:From the Query menu, click Include Actual Execution Plan.Click ! Execute from the toolbar or press F5 to run the query again.The query runs and again displays the results in the Results window. Next to the Results window, a new tab is added named Execution plan.Select the Execution plan tab.By hovering the mouse pointer over each component in the execution plan, you can view the details of each component.its me monty |
|
|
|
|
|
|
Execution Plan