# SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS system procedure

The `SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS` system procedure turns a connection's runtime statistics on or off.

By default, the runtime statistics are turned off. When the `runtimestatistics` attribute is turned on, Derby maintains information about the execution plan for each statement executed within the connection (except for COMMIT) until the attribute is turned off. To turn the `runtimestatistics` attribute off, call the procedure with an argument of zero. To turn the `runtimestatistics` on, call the procedure with any non-zero argument.

For statements that do not return rows, the object is created when all internal processing has completed before returning to the client program. For statements that return rows, the object is created when the first `next()` call returns 0 rows or if a `close()` call is encountered, whichever comes first.

## Syntax

    SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(IN SMALLINT ENABLE)

## Execute privileges

By default, all users have execute privileges on this procedure.

## Example

    -- establish a connection
    -- turn on RUNTIMESTATISTIC for connection:
    CALL SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1);
    -- execute complex query here
    -- step through the result sets
    -- access runtime statistics information:
    CALL SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(0);

Parent topic: Built-in system procedures
Related reference
SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS system function
SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING system procedure