Opening book details…
Can I read Execution Plan Basics - Content on EtoBox?
Execution Plan Basics - Content by Kevin Anderson is a document available to read on EtoBox.
What is Execution Plan Basics - Content about?
The document discusses execution plans in SQL Server, including: 1) What happens when a query is submitted - it goes through parsing, optimization, and execution. 2) The differences between estimated and actual execution plans. 3) How to read graphical, text, and XML execution plans and interpret the operations shown. 4) Examples of single table queries like scans, seeks, lookups and how to interpret them. 5) Examples of joins like hash matches, nested loops, and how to interpret them.
- Author
- Kevin Anderson
- Language
- EN