Graphical Execution Plans for Simple SQL Queries

The aim of the article is to enable you to interpret basic graphical execution plans, in other words, execution plans for simple SELECT, UPDATE, INSERT or DELETE queries, with only a few joins and no advanced functions or hints. In order to do this, we'll cover the following graphical execution plan topics:

• Operators – introduced in the last article, now you'll see more
• Joins – what's a relational system without the joins between tables
• WHERE clause – you need to filter your data and it does affect the execution plans
• Aggregates – how grouping data changes execution plans
• Insert, Update and Delete execution plans

Graphical Execution Plans for Simple SQL Queries [via]