SYSCS_UTIL.SET_STATISTICS_TIMING

When statistics timing is turned on, you can track the timing of various aspects of a statement execution. When statistics timing is turned off, all timing values are set to zero.

Statistics timing is an attribute associated with a connection that you turn on and off by using the SYSCS_UTIL.SET_STATISTICS_TIMING system procedure. Statistics timing is turned off by default. Turn statistics timing on only when the statistics are being collected with SYSCS_UTIL.SET_EXPLAIN_CONNECTION. If you turn statistics timing on before enabling statistics collection with SYSCS_UTIL.SET_EXPLAIN_CONNECTION, the procedure has no effect.

Turn statistics timing on by calling this procedure with a non-zero argument. Turn statistics timing off by calling the procedure with a zero argument. See Capture Query Plans for All Statements.

Syntax

SYSCS_UTIL.SET_STATISTICS_TIMING(IN SMALLINT ENABLE)

Example

To enable statistics timing:

CALL SYSCS_UTIL.SET_STATISTICS_TIMING(1);