DaveWentzel.com            All Things Data

Types of Plans

 

 
Plan Type
Graphical/Text/XML
Estimated or Actual
Notes
Graphical
Graphical
either
easiest to read, may not have all the information you need
SHOWPLAN_ALL
Text
Estimated
contains almost everything you'll need
SHOWPLAN_TEXT
Text
Estimated
limited subset of SHOWPLAN_TEXT.  Probably not needed.
STATISTICS PROFILE
Text
Actual
"actual" version of SHOWPLAN_ALL
SHOWPLAN_XML
XML
Estimated
XML plans provide *all* information
STATISTICS_XML
XML
Actual
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Add new comment