SQL/MX 3.x Query Guide (H06.22+, J06.11+)

SQL/MX Operators
HP NonStop SQL/MX Query Guide—640323-001
7-8
CURSOR_DELETE Operator
The following is an example of the CURSOR_DELETE operator:
PREPARE TestQuery1 FROM
DELETE FROM customer
WHERE c_nationkey<300;
DESCRIPTION
olt_optimization ....... used
fragment_id ............ 3
parent_frag ............ 0
fragment_type .......... dp2
Scan_Direction ......... forward
olt_optimization ....... used
olt_opt_lean ........... not used
iud_type ............... index_ cursor_delete
DETCAT.DETSCH.CX1
lock_mode .............. not specified, defaulted to lock
cursor
access_mode ............ not specified, defaulted to read
committed
columns_retrieved ...... 3
begin_key .............. (C_NATIONKEY =
DETCAT.DETSCH.CUSTOMER.C_NATIONKEY)
and (C_CUSTKEY =
DETCAT.DETSCH.CUSTOMER.C_CUSTKEY)
fragment_type Master, ESP, or DP2. text
olt_optimization Indicates whether an optimization for short and
simple operations is used. Its value is 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
iud_type Type of delete followed by table or index name. expr(text)
begin_key Expression of the begin key predicates. expr(text)
index_begin_key Expression of the begin key predicates on
index.
expr(text)
part_key_predicate Predicate expression specified on partitioning
key. Displayed only if partitioning key differs
from clustering key.
expr(text)
check_constraint Check constrains in the delete table. expr(text)