SQL/MX 3.2 Query Guide (H06.25+, J06.14+)

SQL/MX Operators
HP NonStop SQL/MX Release 3.2 Query Guide—663851-002
7-84
UNIQUE_UPDATE Operator
parent_frag ............ 0
fragment_type .......... dp2
Scan_Direction ......... forward
olt_optimization ....... used
olt_opt_lean ........... used
iud_type ............... unique_delete DETCAT.DETSCH.TT22
lock_mode .............. not specified, defaulted to lock
cursor
access_mode ............ not specified, defaulted to read
committed
columns_retrieved ...... 2
key ..................... (F1 = %(46))
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 following:
Token Followed by ... Data Type
fragment_id A sequential number assigned to the fragment. 0
is always the master executor and 1 is reserved
for the EXPLAIN plan. Numbers 2 to n will be
ESP or DAM fragments.
integer
parent_frag The fragment_id for the parent of the current
fragment. The value is (none) for the master
executor.
integer
fragment_type Master, ESP, or DP2. text
new_rec_expr Computation of the row to be updated expr(text)
predicate Expression specified on WHERE clause that is
not reflected in the begin and end predicates.
expr(text)
key Expression of the key predicate. expr(text)
index_key Expression of the key predicates on index. expr(text)
olt_optimization Indicates whether an optimization for short,
simple operations is used. The value used or
not used.
text
olt_opt_lean Indicates for short, simple operations whether a
further optimization that reduces the physical
size of the plan is used. Its value is used or not
used.
text
TP663851.fm Page 84 Thursday, August 2, 2012 4:47 PM