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

Operators and Operator Groups
HP NonStop SQL/MX Query Guide—523728-003
7-18
INDEX_SCAN Operator
GROUP BY o_orderpriority
ORDER BY o_orderpriority;
3 6 7 hybrid_hash_semi_join
hash_join_predicate:
(indexcol(\TESTSYS.$BIG18A.TPCD2X.ORDERS.O_ORDERKEY) =
indexcol(\TESTSYS.$BIG18A.TPCD2X.LINEITEM.L_ORDERKEY))
join_type: inner semi
join_method: hash
parallel_join_type: 1
INDEX_SCAN Operator
DAM Subset Group
The INDEX_SCAN operator scans the index built on the key columns. The node
description contains details about how a certain access path is scanned, such as
lock_mode and scan_direction.
The INDEX_SCAN 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 followed
by table name
text
scan_direction Forward or reverse text
lock_mode No lock, share lock, or
exclusive lock
text
access_mode Read uncommitted, read
committed, or
serializable
text
key_type Simple or MDAM text
executor_predicates Any predicate
expression that is not a
key predicate
expr(text)