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

Operators and Operator Groups
HP NonStop SQL/MX Query Guide—523728-003
7-12
HASH_GROUPBY Operator
AND r1.r_name = 'EUROPE’
ORDER BY s_acctbal desc, n_name, s_name, p_partkey;
? XX
211862597476194167 8 FILE_SCAN_UNIQUE
? ? SUPPLIER
(\TESTSYS.$DATA14.SPTPCD.SUPPLIER)
1.0000000E+000 2.8289675E-001 2.8289675E-001 CPU_TIME:
0.001129 IO_TIME: 0.020397 MSG_TIME: 0 IDLETIME: 0.2625
PROBES: 10
key_columns:
indexcol(\TESTSYS.$DATA14.SPTPCD.SUPPLIER.S_SUPPKEY)
part_key_predicates:
VEGPred_1297(VEG{SUPPLIER.S_SUPPKEY(828),\TESTSYS.$DATA14.SPTPCD
.SUPPLIER.S_SUPPKEY(835),\TESTSYS.$DATA14.SPTPCD.SX1.S_SUPPKEY(8
53),\TESTSYS.$DATA14.SPTPCD.SX1.S_SUPPKEY(854),PARTSUPP.PS_SUPPK
EY(1069),\TESTSYS.$DATA14.SPTPCD.PARTSUPP.PS_SUPPKEY(1074),\TEST
SYS.$DATA14.SPTPCD.PSX1.PS_SUPPKEY(1088),\TESTSYS.$DATA14.SPTPCD
.PSX1.PS_SUPPKEY(1092),\TESTSYS.$DATA14.SPTPCD.PSX2.PS_SUPPKEY(1
104),\TESTSYS.$DATA14.SPTPCD.PSX2.PS_SUPPKEY(1108)})
begin_key: (indexcol(\TESTSYS.$DATA14.SPTPCD.SUPPLIER.S_SUPPKEY)
= indexcol(\TESTSYS.$DATA14.SPTPCD.PARTSUPP.PS_SUPPKEY))
end_key: (indexcol(\TESTSYS.$DATA14.SPTPCD.SUPPLIER.S_SUPPKEY) =
indexcol(\TESTSYS.$DATA14.SPTPCD.PARTSUPP.PS_SUPPKEY))
scan_type: file_scan_unique \TESTSYS.$DATA14.SPTPCD.SUPPLIER
SUPPLIER
key_type: simple
lock_mode: not specified
access_mode: not specified
columns_retrieved: 7
fast_replydata_move: used
HASH_GROUPBY Operator
Groupby Group
The HASH_GROUPBY operator describes a portion of an execution plan that affects a
group. The group values are computed by hashing individual rows into a hash table.
When a new row is received, the executor hashes to the hash table and performs the
aggregate in the hash table.
The HASH_GROUPBY operator has one child node. The description field for this
operator contains:
Token Followed by ... Data Type
aggregates Expression of the aggregate
functions
expr(text)
selection_predicates Expression of the having
clause
expr(text)
grouping_columns Expression of the grouping
columns
expr(text)