SQL/MX 3.2.1 Query Guide (H06.26+, J06.15+)

SQL/MX Operators
HP NonStop SQL/MX Release 3.2.1 Query Guide—663851-003
7-59
PARTITION_ACCESS Operator
buffer_size Buffer size for messages between
PARTITION_ACCESS operator and
DAM.
integer
record_length Length of the record that is returned by
DAM.
integer
begin_key_preds
(incl | excl)
Predicates to determine the begin key,
which might include or exclude the
specified key.
expr(text)
end_key_preds
(incl | excl)
Predicates to determine the end key,
which might include or exclude the
specified key.
expr(text)
begin_key_exclusion_expr Boolean expression indicating whether
the begin key is excluded from the key
range (in cases where this is
determined dynamically).
expr(text)
end_key_exclusion_expr Boolean expression indicating whether
the end key is excluded from the key
range (in cases where this is
determined dynamically).
expr(text)
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
Token Followed by ... Data Type
TP663851.fm Page 59 Wednesday, January 30, 2013 5:37 PM