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

Operators and Operator Groups
HP NonStop SQL/MX Query Guide—523728-003
7-19
INDEX_SCAN Operator
The example of the INDEX_SCAN 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 22 INDEX_SCAN
? ? SUPPLIER
(\TESTSYS.$DATA14.SPTPCD.SUPPLIER)
1.0000000E+002 2.1277186E-001 2.1277186E-001
CPU_TIME: 0.001533 IO_TIME: 0.020272 MSG_TIME: 0
IDLETIME: 0.1925 PROBES: 1
key_columns: indexcol(\TESTSYS.$DATA14.SPTPCD.SX1.S_NATIONKEY),
indexcol(\TESTSYS.$DATA14.SPTPCD.SX1.S_SUPPKEY)
executor_predicates:
(indexcol(\TESTSYS.$DATA14.SPTPCD.SX1.S_SUPPKEY) =
indexcol(\TESTSYS.$DATA14.SPTPCD.SX1.S_SUPPKEY))
begin_key: (indexcol(\TESTSYS.$DATA14.SPTPCD.SX1.S_NATIONKEY) =
-2147483648), (indexcol(\TESTSYS.$DATA14.SPTPCD.SX1.S_SUPPKEY) =
-2147483648)
columns_retrieved Estimate of the number
of columns to be
returned
integer
fast_replydata_move An indicator that shows
whether an optimization
for returning data from
DAM is used. The value
used is returned if this
optimization is used.
text
fast_scan An indicator that shows
whether an optimization
for simple scan
operations is used. The
value used is returned if
this optimization is used.
text
Token Followed by ... Data Type