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

SQL/MX Operators
HP NonStop SQL/MX Query Guide—640323-001
7-71
SUBSET_DELETE Operator
parent_processes ....... 1
child_processes .......... 3 parent_partitioning_fun grouped
1 to 3,PAPA with 3 PA(s),
exactly 1 partition
child_partitioning_func range
partitioned 3 ways on
(T03.SINT32_UNIQ)
SUBSET_DELETE Operator
DAM Subset Group
The SUBSET_DELETE operator describes a portion of an execution plan that details
how a certain access path is scanned: it deletes more than one row. A subset
operation performs the read and delete in a combined operation. This operation differs
from CURSOR_DELETE, which performs the read and delete in separate operations.
The CURSOR_DELETE operation also involves more messages.
This operator has no child nodes. The description field for this operator contains:
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
iud_type Type of delete followed by table or index name. expr(text)
predicate Expression specified in WHERE clause. expr(text)
part_key_predicate Predicate expression specified on partitioning
key. It is displayed only if partitioning key differs
from clustering key.
expr(text)
begin_key Expression of the begin key predicate. expr(text)
index_begin_key Expression of the begin key predicates on
index.
expr(text)
end_key Expression of the end key predicate. expr(text)
index_end_key Expression of the end key predicates on index. expr(text)
check_constraint Check constrains in the table. expr(text)
scan_type Information on indexes. text
scan_direction Direction in which table is scanned: forward or
reverse.
text