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

Operators and Operator Groups
HP NonStop SQL/MX Query Guide—523728-003
7-21
INSERT Operator
The example of the INDEX_SCAN_UNIQUE operator is based on:
SELECT a.ten, max(a.unique2)
FROM $big18a.wisc32m.abase a, $big18a.wisc32m.bbase b
WHERE a.unique2=b.unique3 AND a.onepercent = 90
GROUP BY a.ten;
. . 4 index_scan_unique
key_columns: indexcol(\TESTSYS.$BIG18A.WISC32M.IXB4.UNIQUE3)
part_key_predicates:
VEGPred_170(VEG{A.UNIQUE2(32),\TESTSYS.$BIG18A.WISC32M.ABASE.UNI
QUE2(48),\TESTSYS.$BIG18A.WISC32M.IXA4.UNIQUE2(73),B.UNIQUE3(121
),\TESTSYS.$BIG18A.WISC32M.BBASE.UNIQUE3(137),\TESTSYS.$BIG18A.W
ISC32M.IXB4.UNIQUE3(152)})
begin_key: (indexcol(\TESTSYS.$BIG18A.WISC32M.IXB4.UNIQUE3) =
indexcol(\TESTSYS.$BIG18A.WISC32M.ABASE.UNIQUE2))
end_key: (indexcol(\TESTSYS.$BIG18A.WISC32M.IXB4.UNIQUE3) =
indexcol(\TESTSYS.$BIG18A.WISC32M.ABASE.UNIQUE2))
scan_type: index_scan_unique
\TESTSYS.$BIG18A.WISC32M.IXB4(\TESTSYS.$BIG18A.WISC32M.BBASE B)
key_type: simple
lock_mode: not specified
access_mode: not specified
columns_retrieved: 3
INSERT Operator
INSERT Group
The INSERT operator describes that part of an execution plan that inserts a new row
into a table. The operator for an INSERT operator is always INSERT.
fast_replydata_move An indicator that shows
whether an optimization for
returning data from DAM is
used. The value used is
returned if this optimization is
used.
text
fast_scan An indicator that shows
whether an optimization for
simple scan operations is
used. The value used is
returned if this optimization is
used.
text
olt_optimization An indicator that shows
whether an optimization for
short, simple operations is
used. The value used is
returned if this optimization is
used.
text