DaveWentzel.com            All Things Data

Execution Plans Home


Query Execution Plan Performance
Graphical Plan Information
Various Query Plan Topics
Other Items
Useful Links
Types of Plans discusses which commands and types of plans are estimated vs actual.
http://msdn2.microsoft.com/en-us/library/ms175913.aspx :  what the graphical execution plan icons mean. 
Predicate Implication  --discusses Predicate Pushdown, is it better to place non-JOIN criteria in the JOIN or WHERE clause, etc. 

Other Common Icons You See in Graphical Plans

     Blocking and non-blocking Operators

Parameterization...parameter sniffing, OPTIMIZE FOR, etc
Query Fingerprints
**Important Note** encrypted procedures will never display an execution plan.