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.

19 comments:

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 สล็อตออนไลน์ทำเงินได้ดีที่สุด

Cannon said...

I gained knowledge from your article, Thank youทีเด็ดบอลวันนี้ ผลบอลเมื่อวาน

phkhnsmburn said...

That's good news, I've been following for a long time.ทรรศนะบอลคืนนี้ I am always searching online for storys that can accommodate me ทีเด็ดบอลเต็ง

ball said...

ลิเวอร์พูลIt is extremely helpful for me.ข่าวหงส์แดง

ball said...

ประวัตินักเตะลิเวอร์พูลIt is extremely helpful for me.ประวัตินักเตะหงส์แดง

tanapol said...

Follow up here Today we have a good sports website for you to follow. Click here.ผลบอลสด7mscore

sk said...

This article is good, interesting and informative.
ช่วงเวลาเล่นสล็อตpg

sk said...

It's a new knowledge that I have come to know. The article contains good and valuable content
รีวิวไพ่เสือมังกร

wanon said...

This is a great web site, Good sparkling user interface and, very informative blogs. thanks. You may check our website also ลองเล่นเกมพีจีสล็อต

Comfortreview said...

Thank you for your good content. เว็บสล็อตออนไลน์ที่ดีที่สุด

tungkuay said...

I want a way to contact my friends.
เกมโชว์ Evolution365

sk said...

This article is good, there is a magic in this article too.

ค่ายPG SLOT

pgSlot365x said...

I will bookmark your site and take the feeds additionally..... Evo casinoเครดิตฟรี

Post a Comment

Ads