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

Operators and Operator Groups
HP NonStop SQL/MX Query Guide—523728-003
7-8
EXPLAIN Operator
GROUP BY supp_nation, cust_nation, yr
ORDER BY supp_nation, cust_nation, yr;
211862597572632956 16 ESP_EXCHANGE 15 ?
1.1108888E+001 1.9247573E-001 2.2068891E+000 CPU_TIME:
0.966086 IO_TIME: 0.101359 MSG_TIME: 0.071711 IDLETIME: 1.2408
PROBES: 1
bottom_partition_input_values: \:_sys_HostVarLo0,
\:_sys_HostVarHi0, \:_sys_hostVarExclRange
buffer_size: 4166
record_length: 24
top_degree_parallelism: 1
bottom_degree_parallelism: 3
top_num_data_streams: 1
bottom_num_data_streams: 3
bottom_partitioning_function: range partitioned 3 ways on
(([1583]equiv(LINEITEM.L_ORDERKEY) ))
EXPLAIN Operator
Stored Function Group
The EXPLAIN operator executes a stored function. The operator for an EXPLAIN
operator is always EXPLAIN.
EXPLAIN has no child nodes. The description field for this operator contains:
EXPR Operator
Tuple Group
The EXPR operator calculates an expression for each row it receives from its child
node and returns that expression to its parent node.
The EXPR operator has one child node. The description field for this operator contains:
FILE_SCAN Operator
DAM Subset Group
The FILE_SCAN operator contains details about how a certain access path is
scanned, such as lock_mode and scan_direction.
Token Followed by ... Data Type
procedure_parameters Parameters from the call to
the EXPLAIN function
expr(text)
Token Followed by ... Data Type
tuple_expr The tuple produced by this node expr(text)