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

Operators and Operator Groups
HP NonStop SQL/MX Query Guide—523728-003
7-55
UNIQUE_UPDATE Operator
UNIQUE_UPDATE Operator
DAM Unique Group
The UNIQUE_UPDATE operator describes a portion of an execution plan that works
on one row only; it updates zero or one row.
The UNIQUE_UPDATE operator has no child nodes. The description field for this
operator contains:
The example of the UNIQUE_UPDATE operator is based on:
UPDATE ORDERS SET O_CARRIER_ID = ?Carrier_ID
WHERE (O_W_ID, O_D_ID, O_ID) = (?W_ID, ?D_ID, ?O_ID);
? XX
211862680734184570 1 UNIQUE_UPDATE
? ? \TESTSYS.$BIG18B.OEQA8.ORDERS
2.4857715E+001 4.1293062E-002 4.1293062E-002
CPU_TIME: 0.000819 IO_TIME: 0.041293 MSG_TIME: 0 IDLETIME: 0
PROBES: 1
new_rec_expr: ("\TESTSYS.$SQL09".OEQA8.ORDERS.O_CARRIER_ID
assign ?Carrier_ID)
part_key_predicates: VEGPred_118(VEG{ORDERS.O_W_ID(15),
\TESTSYS.$BIG18B.OEQA8.ORDERS.O_W_ID(23),
\TESTSYS.$BIG18B.OEQA8.ORDER1.O_W_ID(41),
\TESTSYS.$BIG18B.OEQA8.ORDER1.O_W_ID(45),?W_ID(61),
"\TESTSYS.$SQL09".OEQA8.ORDERS.O_W_ID(67),
\TESTSYS.$BIG18B.OEQA8.ORDERS.O_W_ID(75),
\TESTSYS.$BIG18B.OEQA8.ORDER1.O_W_ID(93),
\TESTSYS.$BIG18B.OEQA8.ORDER1.O_W_ID(97)}) and
VEGPred_121(VEG{ORDERS.O_D_ID(16),
\TESTSYS.$BIG18B.OEQA8.ORDERS.O_D_ID(24),
\TESTSYS.$BIG18B.OEQA8.ORDER1.O_D_ID(42),
\TESTSYS.$BIG18B.OEQA8.ORDER1.O_D_ID(46),?D_ID(62),
"\TESTSYS.$SQL09".OEQA8.ORDERS.O_D_ID(68),
\TESTSYS.$BIG18B.OEQA8.ORDERS.O_D_ID(76),
\TESTSYS.$BIG18B.OEQA8.ORDER1.O_D_ID(94),
Token Followed by ... Data Type
new_rec_expr Computation of the row to be
updated
expr(text)
begin_key Expression of the key
predicates
expr(text)
end_key Expression of the key
predicates
expr(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