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

Operators and Operator Groups
HP NonStop SQL/MX Query Guide—523728-003
7-49
SPLIT_TOP Operator
9.9999997E-003 3.0513660E-004 1.7417581E+000 CPU_TIME:
0.357311 IO_TIME: 0.056431 MSG_TIME: 0.067074 IDLETIME: 0
PROBES: 10
aggregates:
min(indexcol(\TESTSYS.$DATA14.SPTPCD.PARTSUPP.PS_SUPPLYCOST))
selection_predicates:
(indexcol(\TESTSYS.$DATA14.SPTPCD.PARTSUPP.PS_SUPPLYCOST) =
min(indexcol(\TESTSYS.$DATA14.SPTPCD.PARTSUPP.PS_SUPPLYCOST)))
SPLIT_TOP Operator
Exchange Group
The SPLIT_TOP operator describes a portion of an execution plan for a file system
interface in which requests to DAM occur with some level of parallel processing. The
operator for a SPLIT_TOP operator is always SPLIT_TOP. For more information about
exchange operators, see Section 8, Parallelism.
The SPLIT_TOP operator has one child node. The description field for this operator
contains:
The example of the SPLIT_TOP 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
Token Followed by ... Data Type
top_degree_parallelism Number of fragment instances
of the fragment containing the
SPLIT_TOP node that exist
integer
bottom_degree_parallelism Number of partitions integer
top_num_data_streams Number of partitions integer
bottom_num_data_streams Number of partitions integer
bottom_partitioning_function Details the type of partitioning
and contains summary
information about the parallel
plan
text