SYSXPLAIN_RESULTSETS system table
Derby Reference Manual
244
Column Name
Type
Length
Nullable
Contents
EXECUTE_TIME
BIGINT
20
false
The time in milliseconds
that Derby took to
execute this statement.
BEGIN_COMP_TIME
TIMESTAMP 29
false
The time at which
Derby began to compile
this statement.
END_COMP_TIME
TIMESTAMP 29
false
The time at which
Derby finished
compiling this
statement.
BEGIN_EXE_TIME
TIMESTAMP 29
false
The time at which
Derby began to execute
this statement.
END_EXE_TIME
TIMESTAMP 29
false
The time at which
Derby finished
executing this
statement.
SYSXPLAIN_RESULTSETS system table
The SYSXPLAIN_RESULTSETS table captures information about each result set which
is part of a statement that has been executed using RUNTIMESTATISTICS with XPLAIN
style.
See "Working with RunTimeStatistics" in Tuning Derby for information on how to
configure this.
Most statements have at least one result set associated with them, and some complex
statements may have many result sets associated with them. Some statements, for
example DDL statements such as CREATE TABLE, have no result sets associated with
them.
Each row in this table describes a particular result set used by a particular statement.
Rows in this table are typically joined with rows in SYSXPLAIN_STATEMENTS during
analysis:
select st.stmt_text, rs.op_identifier
from my_stats.sysxplain_statements st
join my_stats.sysxplain_resultsets rs
on st.stmt_id = rs.stmt_id
Rows in this table are added automatically when Derby 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_RESULTSETS system table.
Table 64.
SYSXPLAIN_RESULTSETS system table
Column Name
Type
Length
Nullable
Contents
RS_ID
CHAR
36
false
A unique identifier for
this particular row.
OP_IDENTIFIER
VARCHAR
32,672
false
A code indicating
what type of result
