The Basics of Execution Plans and SHOWPLAN in SQL Server

This video is part of LearnItFirst's Transact-SQL Programming: SQL Server 2008/R2 course. More information on this video and course is available here:

http://www.learnitfirst.com/Course/161/SQL-Programming-2008.aspx?an=YouTube

Many of the ideas in this video will be revisited in chapters 5 and 11, so expect mostly basics here - details will come in later videos. Using the query from the last video, trainer Scott Whigham discusses execution plans. How can you uncover the steps SQL Server went through to arrive at the results? What is SHOWPLAN?

Highlights from this video:

* What does the execution plan tell us?
* How can you look at the execution plan?
* Estimated Execution Plan vs. Actual Execution Plan
* How does SQL Server choose indexes?
* Analyzing and understanding graphical execution plans
* Determining costs of the components of execution
* Using SHOWPLAN

and much more

Category:

Science & Technology

Tags:

• sql server 2008
• r2
• execution plan
• estimated
• actual
• index
• cost
• showplan
• training
• lesson
• instruction

[MegaPhobo]

Very Nice! Continue making such nice and helpful videos!

[mrao1982]

Thanks Scott .. that was clear and helpful

[rizouu8]

Thank you :)