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 |
|
Da_Retina
Posting Yak Master
109 Posts |
 Posted - 2001-12-30 : 04:37:43
|
| Salute to All..How can I read an execution plan in the query analyzer?..How can I decide depending on the plan?Thanks In Advance |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2001-12-30 : 07:23:36
|
| Click on Query in the Menu , you will find Show Execution plan click on it. or a press Ctrl+k after selecting you query. you will be displayed the execution plan of the query you have selected.Depending on the settings , you will be displayed the cost of running the query with the intermediate steps it takes. most of the time by creating proper indexes you can fine tune your query. overall there is nothing like a good desing in getting a efficent system.there is an article by Graz on performance tuning ,follow this linkhttp://www.sqlteam.com/item.asp?ItemID=6891 and you will learn a lot on understanding a query performance and working you way for its better performance.HTH-------------------------Graz's Baby is my Master:) |
 |
|
|
Da_Retina
Posting Yak Master
109 Posts |
Posted - 2001-12-31 : 02:14:15
|
| Thanks for the help ..I need to know how to interpret the flow charts?..Thanks In Advance |
|
|
|
izaltsman
A custom title
1139 Posts |
|
|
|
|
|
EXECUTION PLAN