<< SYSXPLAIN_STATEMENT_TIMINGS system table | SYSXPLAIN_RESULTSETS system table >>

OPTIMIZE_TIME

<< SYSXPLAIN_STATEMENT_TIMINGS system table | SYSXPLAIN_RESULTSETS system table >>

Derby Reference Manual

243

Column Name

Type

Length

Nullable

Contents

TIMING_ID

CHAR

false

A unique identifier for
this particular row. This
column can be used to
join with the TIMING_ID
column in SYSXPLAIN_STATEMENTS
to match statement
timings with their
corresponding
statements.

PARSE_TIME

BIGINT

false

The time in milliseconds
that Derby took to parse
this statement.

BIND_TIME

BIGINT

false

The time in milliseconds
that Derby took to
bind this statement.
Binding a statement
is the process of
resolving table and
column references in
the statement against
the table and column
definitions in the system
catalogs.

OPTIMIZE_TIME

BIGINT

false

The time in milliseconds
that Derby took to
optimize this statement.
During optimization,
Derby considers
the various possible
execution plans that
could be used for the
statement, and chooses
the one it thinks will be
best.

GENERATE_TIME

BIGINT

false

The time in milliseconds
that Derby took to
generate code for this
statement.

COMPILE_TIME

BIGINT

false

The time in milliseconds
that Derby took to
compile this statement.
Overall statement time
is divided into compile
time and execute time,
and the compile time is
further sub-divided into
parse, bind, optimize,
and generate time.