SQL/MX 2.x Query Guide (H06.04+, J06.03+)

SQL/MX Operators
HP NonStop SQL/MX Query Guide—540437-005
7-56
ROOT Operator
The example of the PARTITION_ACCESS operator is based on:
prepare TestQuery17 from
select T03.char_100
from PTAB03 T03
where T03.char_100 =
(Select min(T00.char_10)
from PTAB00 T00
);
DESCRIPTION
fragment_id ............ 2
parent_frag ............ 0
fragment_type .......... dp2
buffer_size ............ 31,000
record_length .......... 11
space_usage ............ 19:8:8:40
eid_space_computation on
begin_key_preds_(incl)
(DETCAT.DETSCH.PTAB00.SINT32_UNIQ =
<min>)
end_key_preds_(incl) ... (DETCAT.DETSCH.PTAB00.SINT32_UNIQ =
<max>)
begin_part_no_expr ..... \:_sys_hostVarPAPartNo_1606919584
end_part_no_expr ......... \:_sys_hostVarPAPartNo_1606919584
ROOT Operator
Root Group
The ROOT operator is the root, or the top node, of an execution plan and describes the
SQL query. The operator for a ROOT is always ROOT.
The ROOT operator has one child. The description field for this operator contains:
child_partitioning_function Type of bottom partitioning and contains
summary information about the parallel
plan.
text
begin_part_selection_expr Expression used by SPLIT_TOP or
PARTITION_ACCESS to compute the
begin_part_no_expr.
expr(text)
end_part_selection_expr Expression used by SPLIT_TOP or
PARTITION_ACCESS to text compute
the end_part_no_expr.
expr(text)
Token Followed by ... Data Type
statement Original SQL statement text
select_list Expression of the SELECT list columns expr(text)
Token Followed by ... Data Type