SQL Language Reference / Procedures |
Enables or disables capturing query execution plans and statistics for the current connection.
After enabling query execution plan capture, you can optionally enable statistics timing using SYSCS_UTIL.SET_STATISTICS_TIMING.
Enable query execution plan capture by calling this procedure with a non-zero argument. Disable capture by calling the procedure with a zero argument. See Capture Query Plans for All Statements.
SYSCS_UTIL.SET_EXPLAIN_CONNECTION(IN SMALLINT ENABLE)
To begin capturing execution plans for the current connection:
CALL SYSCS_UTIL.SET_EXPLAIN_CONNECTION(1);