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

Operators and Operator Groups
HP NonStop SQL/MX Query Guide—523728-003
7-44
SORT Operator
SORT Operator
Sort Group
A SORT operator describes a portion of an execution plan that performs a sort. The
operator for a SORT operator is always SORT.
The SORT operator has one child node. The description field for this operator contains:
The example of the SORT operator is based on:
SELECT s_acctbal, s_name, n_name, p_partkey, p_mfgr, s_address,
s_phone, s_comment
FROM part,supplier,partsupp, nation, region
WHERE p_partkey = ps_partkey
AND s_suppkey = ps_suppkey
AND p_size = 15
AND p_type like '%BRASS'
AND s_nationkey = n_nationkey
AND n_regionkey = r_regionkey
AND r_name = 'EUROPE'
AND ps_supplycost = (SELECT MIN(ps_supplycost)
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 18 SORT
1 7 ?
1.0000000E+001 1.4229869E-001 2.0431513E+000 CPU_TIME:
0.000463 IO_TIME: 0 MSG_TIME: 0 IDLETIME: 0
PROBES: 1
sort_key:
inverse(indexcol(\TESTSYS.$DATA14.SPTPCD.SUPPLIER.S_ACCTBAL)),
indexcol(\TESTSYS.$DATA14.SPTPCD.NATION.N_NAME),
indexcol(\TESTSYS.$DATA14.SPTPCD.SUPPLIER.S_NAME),
indexcol(\TESTSYS.$DATA14.SPTPCD.PART.P_PARTKEY)
SORT_GROUPBY Operator
Groupby Group
The SORT_GROUPBY operator describes a portion of an execution plan that affects a
group.
Token Followed by ... Data Type
sort_key Expression describing sort
keys
expr(text)