What is an execution plan? When would you use it? How would you view the execution plan?
What is an execution plan? When would we use it? How would we view the execution plan?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Manikavelu VelayuthamPosted May 10, 2011, 6:47 AM
Based on your query, the plan will be generated.
Its generally used to tune your query based on the plan shown on the screen.
through that you can write a query that could execute very fastly.
it will show you the following information
- Index used
- Hash Joins
- Merge Joins
- Index Seek
- Index Scan
- Lookup table
to learn the execution plan you should know the above terms first.