Visual Explain Options

Visual Explain

• Critical Path Colors
  
  Background: Background color of the nodes in the critical path
  Foreground: Foreground color of the nodes in the critical path
   
• Critical Node Colors
  
  Background of 1st critical node: Background color of the highest cost node
  Foreground of 1st critical node: Foreground color of the highest cost node
  Background of 2nd critical node: Background color of the 2nd highest cost node
  Foreground of 2nd critical node: Foreground color of the 2nd highest cost node
  Background of 3rd critical node: Background color of the 3rd highest cost node
  Foreground of 3rd critical node: Foreground color of the 3rd highest cost node
   
• Critical Operation Colors
  
  Background of 1st critical operation: Background color of 1st level critical operation
  Foreground of 1st critical operation: Foreground color of 1st level critical operation
  Background of 2nd critical operation: Background color of 2nd level critical operation
  Foreground of 2nd critical operation: Foreground color of 2nd level critical operation
  Background of 3rd critical operation: Background color of 3rd level critical operation
  Foreground of 3rd critical operation: Foreground color of 3rd level critical operation
   
• Amazon Redshift Visual Explain
  
  Color critical path: Determines whether to color code the highest cost path in an explain plan
  Color critical nodes: Determines whether to color code the highest cost nodes in an explain plan
  Color critical operations: Determines whether to color code the highest cost operations in an explain plan (i.e. 'Full Table Scan' and 'Cartesian Join')
   
• DB2 LUW Visual Explain
  
  Create explain table: Create explain tables if they do not exist before executing query
  Drop explain table: Drop explain tables after executing query
  Color critical path: Determines on whether to color code the path to the highest cost path in an explain plan
  Color critical nodes: Determines on whether to color code the highest cost nodes in an explain plan
  Color critical operations: Determines on whether to color code the highest cost operations in an explain plan (i.e. ’Full Table Scan’ and ’Cartesian Join’)
   
• DB2 z/OS Visual Explain
  
  Create explain table: Create explain tables if they do not exist before executing query
  Drop explain table: Drop explain tables after executing query
  Color critical path: Determines on whether to color code the path to the highest cost path in an explain plan
  Color critical nodes: Determines on whether to color code the highest cost nodes in an explain plan
  Color critical operations: Determines on whether to color code the highest cost operations in an explain plan (i.e. ’Full Table Scan’ and ’Cartesian Join’)
   
• Greenplum Visual Explain
  
  Enable Explain Analyze: When enabled, the ANALYZE option is turned on and causes the statement to be actually executed, not only planned. The actual run times and other statistics are displayed inside Show Execution Plan or Execute Explain. This parameter defaults to OFF.
  Important: Keep in mind that the statement is actually executed when the ANALYZE option is used. Although EXPLAIN will discard any output that a SELECT would return, other side effects of the statement will happen as usual. Executing EXPLAIN ANALYZE on an INSERT, UPDATE, DELETE, CREATE TABLE AS, or EXECUTE statement will affect your data.
   
• Hive Visual Explain
  
  NONE: Basic explain
  EXTENDED: Produces extra information about the operators in the plan
  DEPENDENCY: Produces extra information about the inputs in the plan
  AUTHORIZATION: Shows all entities needed to be authorized to execute the query and authorization failures if any exist
   
• Impala Visual Explain
  
  MINIMAL: Basic explain. One line per operation
  STANDARD: The default level of detail showing the logical way that work is split up for the distributed query
  EXTENDED: Includes additional detail about how the query planner uses statistics in its decision making process
  VERBOSE: The maximum level of detail showing how work is split up within each node into "query fragments" that are connected in a pipeline
   
• Oracle Visual Explain
  
  Create explain table: Create explain table if it does not exist prior to executing query
  Drop explain table: Drop explain table after executing query
  Use dynamic explain table: Determines whether to use a dynamic explain table name (AQUA_EXPLAIN_[SESSIONID]) or a user defined table
  Explain schema: The schema name of the explain table to use if a user defined explain table is selected
  Explain table: The table name of the explain table to use if a user defined explain table is selected
  Color critical nodes: Determines on whether to color code the highest cost nodes in an explain plan
  Color critical operations: Determines on whether to color code the highest cost operations in an explain plan (i.e. ’Full Table Scan’ and ’Cartesian Join’)
  Display commit warning: Display commit warning when auto-commit is disabled and CREATE/DROP is enabled
   
• PostgreSQL Visual Explain
  
  Enable Explain Analyze: When enabled, the ANALYZE option is turned on and causes the statement to be actually executed, not only planned. The actual run times and other statistics are displayed inside Show Execution Plan or Execute Explain. This parameter defaults to OFF.
  Important: Keep in mind that the statement is actually executed when the ANALYZE option is used. Although EXPLAIN will discard any output that a SELECT would return, other side effects of the statement will happen as usual. Executing EXPLAIN ANALYZE on an INSERT, UPDATE, DELETE, CREATE TABLE AS, or EXECUTE statement will affect your data.
   
• Spark Visual Explain
  
  NONE: Basic explain
  EXTENDED: Produces extra information about the logical plan before and after analysis and optimization
   
• SQL Server Visual Explain
  
  Color critical path: Determines whether to color code the highest cost path in an explain plan
  Color critical nodes: Determines on whether to color code the highest cost nodes in an explain plan
  Color critical operations: Determines on whether to color code the highest cost operations in an explain plan (i.e. ’Full Table Scan’ and ’Cartesian Join’)
   
• Sybase ASE Visual Explain
  
  Explain Plan Type: Chooses the explain plan extraction type

• Teradata Visual Explain
  
  Enable Explain Verbose: When enabled, the VERBOSE option is turned on for the Explain.
  Enable Explain Stats: When enabled, the HELPSTATS option is turned on for the Explain.