SQL/MX 2.x Query Guide (H06.04+, J06.03+)

SQL/MX Operators
HP NonStop SQL/MX Query Guide—540437-005
7-63
SORT_GROUPBY Operator
The example of the SORT operator is based on:
PREPARE TestQuery16 FROM
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;
DESCRIPTION
fragment_id ............ 0
parent_frag ............ (none)
fragment_type ........... master self_referencing_update
forced_sort
sort_key ...............
inverse(DETCAT.DETSCH.SUPPLIER.S_ACCTBAL),
DETCAT.DETSCH.NATION.N_NAME,
DETCAT.DETSCH.SUPPLIER.S_NAME,
DETCAT.DETSCH.PSX1.PS_PARTKEY
SORT_GROUPBY Operator
Groupby Group
The SORT_GROUPBY operator describes a portion of an execution plan that affects a
group.
parent_frag The fragment_id for the parent fragment of the
current fragment. The value is (none) for the
master executor.
integer
fragment_type Master, ESP, or DP2. text
sort_key Expression describing sort keys. expr(text)