SQL/MX 2.x Query Guide (G06.24+, H06.03+)

Operators and Operator Groups
HP NonStop SQL/MX Query Guide—523728-003
7-39
PARTITION_ACCESS Operator
The PARTITION_ACCESS operator has one child node. The description field for this
operator contains:
The example of the PARTITION_ACCESS operator is based on:
SELECT s_acctbal, s_name, n_name, p_partkey, p_mfgr, s_address,
s_phone, s_comment
FROM part,supplier,partsupp, nation, region
WHERE p_partkey = ps_partkey
AND s_suppkey = ps_suppkey
AND p_size = 15
AND p_type like '%BRASS'
AND s_nationkey = n_nationkey
AND n_regionkey = r_regionkey
AND r_name = 'EUROPE'
AND ps_supplycost = (SELECT MIN(ps_supplycost)
Token Followed by ... Data Type
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 An indicator that shows whether an
optimization for short, simple operations
is used. The value used is returned if
this optimization is used.
text