|Built-in System Procedures / Standard Built-in Procedures|
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.
SYSCS_UTIL.SET_STATISTICS_TIMING(IN SMALLINT ENABLE)
To enable statistics timing: