SCAN_QUALIFIERS
BTREE is 2-4; BTREE
heights larger than
this should only be
seen with very large
indexes. A tree with
one page has a height
of 1. Total number of
pages visited in a scan
of a BTREE should be
(BTREE_HEIGHT - 1 +
NO_VISITED_PAGES).
For an extremely small
BTREE, the btree
height may be negative
(-1). For other types of
scans, this column is
NULL.
fetched at a time when
the scan is retrieving
pages from disk.
constraint scans, a
textual representation
of the operator, if any,
which was used to
position the beginning
of the index/constraint
scan.
constraint scans, a
textual representation
of the operator, if any,
which was used to
position the end of the
index/constraint scan.
values which are to
be used to limit the
rows that are scanned,
information about those
values is captured in
this column.
values which are to
be used to limit the
rows that are scanned,
information about those
values is captured in
this column.