SQL/MX 2.x Query Guide (G06.24+, H06.03+)

Operators and Operator Groups
HP NonStop SQL/MX Query Guide—523728-003
7-20
INDEX_SCAN_UNIQUE Operator
end_key: (indexcol(\TESTSYS.$DATA14.SPTPCD.SX1.S_NATIONKEY) =
2147483647), (indexcol(\TESTSYS.$DATA14.SPTPCD.SX1.S_SUPPKEY) =
2147483647)
scan_type: index_scan
\TESTSYS.$DATA14.SPTPCD.SX1(\TESTSYS.$DATA14.SPTPCD.SUPPLIER
SUPPLIER)
scan_direction: forward
key_type: simple
lock_mode: not specified
access_mode: not specified
columns_retrieved: 4
fast_scan: used
fast_replydata_move: used
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
key_columns Columns used as the
primary key
expr(text)
begin_key Expression of the begin key
predicates
expr(text)
end_key Expression of the end key
predicates
expr(text)
scan_type INDEX_SCAN_UNIQUE
followed by table name
text
lock_mode No lock, share, or exclusive
lock
text
key_type Simple or MDAM text
access_mode Read uncommitted, read
committed, or serializable
text
executor_predicates Any predicate expression
that is not a key predicate
expr(text)
columns_retrieved Estimate of the number of
columns to be returned
integer