What is an execution plan? When would you use it? How would you view the execution plan? | SansSQL

Thursday, June 12, 2008

What is an execution plan? When would you use it? How would you view the execution plan?

An execution plan is basically a road map that graphically or textually shows the data retrieval methods chosen by the SQL Server query optimizer for a stored procedure or ad-hoc query and is a very useful tool for a developer to understand the performance characteristics of a query or stored procedure since the plan is the one that SQL Server will place in its cache and use to execute the stored procedure or query. From within Query Analyzer is an option called "Show Execution Plan" (located on the Query drop-down menu). If this option is turned on it will display query execution plan in separate window when query is ran again.


latesttechnologyblogs said...

I feel satisfied to read your blog, you have been delivering a useful & unique information to our vision even you have explained the concept as deep clean without having any uncertainty, keep blogging. SQL server dba Online Training

Keerthi55 said...

MuleSoft training
MuleSoft online training

Huongkvb said...

Aivivu chuyên vé máy bay, tham khảo

giá vé máy bay đi Mỹ khứ hồi

có chuyến bay từ mỹ về việt nam chưa

giá vé máy bay từ canada về Việt Nam

đặt vé máy bay từ nhật về việt nam

gia ve may bay vietjet tu han quoc ve viet nam

Vé máy bay từ Đài Loan về Việt Nam

bảng giá khách sạn cách ly tphcm

vé máy bay chuyên gia sang Việt Nam

Unknown said...

Thanks for posting the best information and the blog is very important.
Servicenow Training In Hyderabad

Dettifoss IT Solutions said...

Thank you a lot for providing individuals with a very spectacular possibility to read critical reviews from this site.
ServiceNow Training in Pune

Unknown said...

Great Article Artificial Intelligence Projects

Project Center in Chennai

JavaScript Training in Chennai

JavaScript Training in Chennai Project Centers in Chennai

Unknown said...

your article is very good Can you give me some advice on my writing method สล็อตออนไลน์ทำเงินได้ดีที่สุด

uday said...

Mule masters Hyderabad,provides 100% job assistance, extending real time projects for practical knowledge this is best course you have interest visit my website link https://mulemasters.in/

Post a Comment