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

Operators and Operator Groups
HP NonStop SQL/MX Query Guide—523728-003
7-40
ROOT Operator
FROM partsupp ps1,supplier s1, nation n1,region r1
WHERE p_partkey = ps1.ps_partkey
AND s1.s_suppkey = ps1.ps_suppkey
AND s1.s_nationkey = n1.n_nationkey
AND n1.n_regionkey = r1.r_regionkey
AND r1.r_name = 'EUROPE’
ORDER BY s_acctbal desc, n_name, s_name, p_partkey;
? XX
211862597476194167 9 PARTITION_ACCESS
8 ?
1.0000000E+000 8.9073047E-002 3.5270255E-001 CPU_TIME:
0.090203 IO_TIME: 0.020397 MSG_TIME: 0.017591 IDLETIME: 0.2625
PROBES: 10
begin_key_preds_(incl):
(indexcol(\TESTSYS.$DATA14.SPTPCD.SUPPLIER.S_SUPPKEY) =
indexcol(\TESTSYS.$DATA14.SPTPCD.PARTSUPP.PS_SUPPKEY))
end_key_preds_(incl):
(indexcol(\TESTSYS.$DATA14.SPTPCD.SUPPLIER.S_SUPPKEY) =
indexcol(\TESTSYS.$DATA14.SPTPCD.PARTSUPP.PS_SUPPKEY))
begin_part_no_expr: \:_sys_hostVarPAPartNo_1283843904
end_part_no_expr: \:_sys_hostVarPAPartNo_1283843904
buffer_size: 31000
record_length: 199
ROOT Operator
Root Group
The ROOT operator is the root, or the top node, of an execution plan and describes the
SQL query. The operator for a ROOT is always ROOT.
The ROOT operator has one child. The description field for this operator contains:
Token Followed by ... Data Type
statement Original SQL statement text
select_list Expression of the SELECT
list
expr(text)
input_variables Expression containing list of
input variables
expr(text)
order_by Expression containing list of
sort keys
expr(text)
must_match When CONTROL QUERY
SHAPE is used, textual
description of forced query
tree ()
expr(text)
update_col The update column
specification of a cursor
declaration
expr(text)