SQL/MX 2.x Query Guide (H06.04+, J06.03+)

SQL/MX Operators
HP NonStop SQL/MX Query Guide—540437-005
7-29
INDEX_SCAN_UNIQUE Operator
fast_scan .............. used
fast_replydata_move .... used
key_columns ............ DETCAT.DETSCH.CX1.C_NATIONKEY,
DETCAT.DETSCH.CX1.C_CUSTKEY
executor_predicates .... (DETCAT.DETSCH.CX1.C_CUSTKEY > 1000)
and(DETCAT.DETSCH.CX1.C_CUSTKEY <
1010) and
(DETCAT.DETSCH.CX1.C_CUSTKEY =
DETCAT.DETSCH.CX1.C_CUSTKEY)
begin_key .............. (DETCAT.DETSCH.CX1.C_NATIONKEY =
<min>),
(DETCAT.DETSCH.CX1.C_CUSTKEY = 1000)
end_key ................ (DETCAT.DETSCH.CX1.C_NATIONKEY =
<max>),
DETCAT.DETSCH.CX1.C_CUSTKEY = 1010)
INDEX_SCAN_UNIQUE Operator
DAM Unique Group
The INDEX_SCAN_UNIQUE operator describes a scan on the primary key column
with an index on that column.
The INDEX_SCAN_UNIQUE operator has no child nodes. The description field for this
operator contains:
Token Followed by ... Data Type
fragment_id A sequential number assigned to the fragment.
0 is always the master executor and 1 is
reserved for the EXPLAIN plan. Numbers 2 to
n will be ESP or DAM fragments.
integer
parent_frag The fragment_id for the parent fragment of the
current fragment. The value is (none) for the
master executor.
integer
fragment_type Master, ESP, or DP2. text
olt_opt_lean Indicates for short, simple operations whether
a further optimization that reduces the physical
size of the plan is used. Its value is used or
not used.
text
key_columns Columns used as the primary key. expr(text)
key Expression of the key predicate. expr(text)
scan_type INDEX_SCAN_UNIQUE followed by table or
index name.
text
lock_mode The lock mode specified: shared, exclusive,
not specified (defaulted to lock cursor), or
unknown.
text
key_type Simple or MDAM. text