See "Working with RunTimeStatistics" in
for information
on how to configure this.
Note in particular that you must
call SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING(1) to enable
timing information to be captured.
Rows in this table are typically joined with rows in
SYSXPLAIN_STATEMENTS and SYSXPLAIN_RESULTSETS during analysis.
For example:
select s.stmt_text, st.execute_time
from my_stats.sysxplain_statements s,
my_stats.sysxplain_statement_timings st
where s.timing_id = st.timing_id
order by st.execute_time desc
Rows in this table are added
automatically when
has been configured appropriately. The
rows remain in the table until you delete them or drop the table.
The following table shows the contents of the SYSXPLAIN_STATEMENT_TIMINGS
system table.
SYSXPLAIN_STATEMENT_TIMINGS system table
For each column in the SYSXPLAIN_STATEMENT_TIMINGS system table, this table provides its data type, its length in bytes, whether it is nullable, and a description of its contents.
Column Name
Type
Length
Nullable
Contents
TIMING_ID
CHAR
36
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
20
false
The time in milliseconds that
took to parse
this statement.
BIND_TIME
BIGINT
20
false
The time in milliseconds that
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
20
false
The time in milliseconds that
took to optimize
this statement. During optimization,
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
20
false
The time in milliseconds that
took to generate
code for this statement.
COMPILE_TIME
BIGINT
20
false
The time in milliseconds that
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.
EXECUTE_TIME
BIGINT
20
false
The time in milliseconds that
took to execute
this statement.
BEGIN_COMP_TIME
TIMESTAMP
29
false
The time at which
began to compile this statement.
END_COMP_TIME
TIMESTAMP
29
false
The time at which
finished
compiling this statement.
BEGIN_EXE_TIME
TIMESTAMP
29
false
The time at which
began to execute
this statement.
END_EXE_TIME
TIMESTAMP
29
false
The time at which
finished
executing this statement.