ENABLE_EXPLAIN_LOG_OUTPUT

The EXPLAIN command returns the processing plan or the plan and the full planner debug log, with the ENABLE_EXPLAIN_LOG_OUTPUT option controlling whether the full planner debug log is part of the EXPLAIN result. The option can have the following values:

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

SQL

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