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-57
PARTITION_ACCESS Operator
(cast(JAVCAT.JAVSCH.T.T3 AS INTEGER
SIGNED)RowsetArrayInto 200 )
PARTITION_ACCESS Operator
Exchange Group
Use the PARTITION_ACCESS operator to describe a portion of an execution plan for a
file system interface in which requests are made to DAM. The DAM process runs in
parallel to the PARTITION_ACCESS (no waited interface). For more information about
exchange operators, see Section 8, Parallelism.
The PARTITION_ACCESS operator has one child node. 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
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)
TP663851.fm Page 57 Monday, October 17, 2011 11:48 AM