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

Operators and Operator Groups
HP NonStop SQL/MX Query Guide—523728-003
7-54
UNIQUE_DELETE Operator
The UNIQUE_DELETE operator has no child nodes. The description field for this
operator contains:
The example of the UNIQUE_DELETE operator is based on:
DELETE FROM norders
WHERE (NO_W_ID, NO_D_ID, NO_O_ID) = (?W_ID, ?D_ID, ?O_ID);
? XX
211862680693186511 1 UNIQUE_DELETE
? ? \TESTSYS.$BIG18B.OEQA8.NORDERS
2.4750000E+001 2.0646531E-002 2.0646531E-002
CPU_TIME: 0.001712 IO_TIME: 0.020647 MSG_TIME: 0 IDLETIME: 0
PROBES: 1
part_key_predicates: VEGPred_49(VEG{NORDERS.NO_W_ID(8),
\TESTSYS.$BIG18B.OEQA8.NORDERS.NO_W_ID(11),?W_ID(24),
"\TESTSYS.$SQL09".OEQA8.NORDERS.NO_W_ID(30),
\TESTSYS.$BIG18B.OEQA8.NORDERS.NO_W_ID(33)}) and
VEGPred_52(VEG{NORDERS.NO_D_ID(9),
\TESTSYS.$BIG18B.OEQA8.NORDERS.NO_D_ID(12),?D_ID(25),
"\TESTSYS.$SQL09".OEQA8.NORDERS.NO_D_ID(31),
\TESTSYS.$BIG18B.OEQA8.NORDERS.NO_D_ID(34)}) and
VEGPred_55(VEG{NORDERS.NO_O_ID(10),
\TESTSYS.$BIG18B.OEQA8.NORDERS.NO_O_ID(13),?O_ID(26),
"\TESTSYS.$SQL09".OEQA8.NORDERS.NO_O_ID(32),
\TESTSYS.$BIG18B.OEQA8.NORDERS.NO_O_ID(35)})
begin_key: (indexcol(\TESTSYS.$BIG18B.OEQA8.NORDERS.NO_W_ID) =
?W_ID) and (indexcol(\TESTSYS.$BIG18B.OEQA8.NORDERS.NO_D_ID) =
?D_ID) and (indexcol(\TESTSYS.$BIG18B.OEQA8.NORDERS.NO_O_ID) =
?O_ID) end_key:
(indexcol(\TESTSYS.$BIG18B.OEQA8.NORDERS.NO_W_ID) = ?W_ID) and
(indexcol(\TESTSYS.$BIG18B.OEQA8.NORDERS.NO_D_ID) = ?D_ID) and
(indexcol(\TESTSYS.$BIG18B.OEQA8.NORDERS.NO_O_ID) = ?O_ID)
olt_optimization: used
Token Followed by ... Data Type
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