SQL/MX 3.1 Query Guide (H06.23+, J06.12+)

SQL/MX Operators
HP NonStop SQL/MX Release 3.1 Query Guide—663851-001
7-58
PARTITION_ACCESS Operator
The following is an example of the PARTITION_ACCESS operator:
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
begin_part_no_expr Expression to calculate the start
partition number (appears instead of
begin_key_preds and
begin_key_exclusion_expr).
expr(text)
end_part_no_expr Expression to calculate the end partition
number (appears instead of
end_key_preds and
end_key_exclusion_expr).
expr(text)
olt_optimization Indicates whether an optimization for
short, simple operations is used. Its
value is used or not used.
text
space_usage One of the following:

Size of packed plan fragment in 1
KB units.

Size of unpacked plan fragment in
1 KB units. Heap (used for
dynamically allocating entities such
as queue entries and diagnostic
areas) size in 1 KB units.

Total size in 1 KB units.
integer
parent_partitioning_function Type of top partitioning and contains
summary information about the parallel
plan.
text
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
TP663851.fm Page 58 Monday, October 17, 2011 11:48 AM