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-12
ESP_ACCESS Operator
The following is an example of the ESP_ACCESS operator:
CREATE SEQUENCE cat.sch.s1;
PREPARE SeqQuery1 FROM SELECT s1.NEXTVAL FROM (VALUES (1)) x;
DESCRIPTION
max_card_est ........... 1
fragment_id ............ 2
parent_frag ............ 0
fragment_type .......... esp
buffer_size ....... 30,720
record_length ......... 16
parent_processes ....... 1
child_processes ........ 1
bottom_node_map ........ (\DMR15:0)
Token Followed by ... Data Type
max_card_est Cardinality estimate for the operator. integer
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 ESP. text
buffer_size Size of message buffer. integer
record_length Number of bytes in the record sent. integer
parent_processes Indicates the number of processes that
the ESPs in the ESP_ACCESS
operator communicate with either
additional ESPs (as indicated by
another ESP_ACCESS operator) or
the master process.
integer
child_processes Indicates the number of processes that
supply the ESPs of an operator with
rows. The number of ROWS_OUT
(also called CARDINALITY) from the
operator that supplies the
ESP_ACCESS operator with data
indicates how many rows the
ESP_ACCESS operator is expected to
receive.
integer
bottom_node_map Associates each process at the bottom
to a processor.
text
TP663851.fm Page 12 Wednesday, January 30, 2013 5:37 PM