EXPLAIN command r eturns processing plan or the plan and the full planner   debug log, with ENABLE_EXPLAIN_LOG_OUTPUT option controlling whether the full planner   debug log is part of EXPLAIN result.OPTIONS には以下の値を指定できます:

Value

Description

TRUE

  • Full planner debug log is part of the EXPLAIN result;
  • Full planner debug log will be printed into the server log 

FALSE

  • Full planner debug log is not part of the EXPLAIN result;
  • The "DEBUG_LOG" column in the EXPLAIN result will have null as value
  • Default value

Example

CALL SYSADMIN.setDefaultOptionValue('ENABLE_EXPLAIN_LOG_OUTPUT', 'TRUE');