NO_INDEX_UPDATES
Derby Reference Manual
245
Column Name
Type
Length
Nullable
Contents
set these statistics
are for. Common
result set types
include TABLESCAN,
INDEXSCAN, and
PROJECTION.
OP_DETAILS
VARCHAR
32,672
true
Additional string
information which
varies for each different
type of result set.
Interpreting this
information currently
requires reading the
Derby source code to
know what values are
being displayed here.
NO_OPENS
INTEGER
10
true
Number of times this
result set was opened
during execution of the
containing statement.
NO_INDEX_UPDATES
INTEGER
10
true
The number of index
updates performed
by this result set. This
value is NULL for
result sets used by
queries, but may have
a non-zero value for
modification statements
such as INSERT,
UPDATE, or DELETE.
LOCK_MODE
CHAR
2
true
A code indicating
the locking level that
was used for this
result set: 'EX' for
exclusive table-level
locking, 'SH' for share
table-level locking, 'IX'
for exclusive row-level
locking, or 'IS' for share
row-level locking.
LOCK_GRANULARITY
CHAR
1
true
A code indicating the
locking granularity
that was used for
this result set: 'T' for
table-level locking, or
'R' for row-level locking.
PARENT_RS_ID
CHAR
36
true
The result sets for a
particular statement
are arranged in a
parent-child tree
structure. The output