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. 
 
 
 
 
 

Add new comment