AFFECTED_ROWS
Derby Reference Manual
246
Column Name
Type
Length
Nullable
Contents
rows from one result
set are delivered as
the input rows to its
parent. This column
stores the identifier
of the parent result
set. For the outermost
result set in a particular
statement, this column
is NULL. Note that
sometimes there are
multiple result sets
with the same parent
result set (that is, some
nodes have multiple
children): for example,
a UNION result set will
have two child result
sets, representing the
two sets of rows which
are UNIONed together.
EST_ROW_COUNT
DOUBLE
52
true
The optimizer's
estimate of the total
number of rows for this
result set.
EST_COST
DOUBLE
52
true
The optimizer's
estimated cost for this
result set. The value
indicates the number
of milliseconds that the
optimizer estimates it
will take to process this
result set.
AFFECTED_ROWS
INTEGER
10
true
This column is non-null
only for INSERT,
UPDATE, and DELETE
result sets. For those
result sets, this column
holds the number
of rows which were
inserted, updated, or
deleted, respectively.
DEFERRED_ROWS
CHAR
1
true
This column is only
non-null for INSERT,
UPDATE, and DELETE
result sets. For those
result sets, this column
holds 'Y' if the INSERT/
UPDATE/DELETE
is being performed
using deferred change
semantics, and