SQL/MX 3.2 Query Guide (H06.25+, J06.14+)

SQL/MX Operators
HP NonStop SQL/MX Release 3.2 Query Guide—663851-002
7-57
PARTITION_ACCESS Operator
(cast(JAVCAT.JAVSCH.T.T2 AS
INTEGER SIGNED) RowsetArrayInto 200),
(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 the following:
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 Thursday, August 2, 2012 4:47 PM