SEEN_ROWS_RIGHT

<< AFFECTED_ROWS | EMPTY_RIGHT_ROWS >>

Derby Reference Manual

247

Column Name

Type

Length

Nullable

Contents

holds 'N' otherwise.
Deferred change
semantics are used
when self-referencing is
taking place.

INPUT_ROWS

INTEGER

true

This column is used for
SORT, AGGREGATE,
and GROUPBY result
sets, and indicates the
number of rows that
were input to the result
set, and thus were
sorted by the sorter.

SEEN_ROWS

INTEGER

true

For join and set nodes,
this is the number of
rows seen by the "left"
side of the processing.
For aggregate, group,
sort, normalize,
materialize, and certain
other nodes, this is the
number of rows seen.

SEEN_ROWS_RIGHT

INTEGER

true

For join and set nodes,
this is the number of
rows seen by the "right"
side of the processing.
For example, in the
statement

select country
from countries
union
select country
from countries
where region =
'Africa'

the UNION
result set has
SEEN_ROWS = 6 and
SEEN_ROWS_RIGHT
= 19.

FILTERED_ROWS

INTEGER

true

This column holds the
number of rows which
were eliminated from
the result set during
processing.

RETURNED_ROWS

INTEGER

true

This column holds the
number of rows which
were returned by the
result set to its caller.
Generally speaking,
the number of returned