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

Operators and Operator Groups
HP NonStop SQL/MX Query Guide—523728-003
7-10
FILE_SCAN_UNIQUE Operator
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;
211862597476194167 1 FILE_SCAN
? ? PART (\TESTSYS.$DATA14.SPTPCD.PART)
1.0000000E+001 1.1565582E+000 1.1565582E+000 CPU_TIME:
0.001258 IO_TIME: 0.054058 MSG_TIME: 0 IDLETIME: 1.1025
PROBES: 1
key_columns: indexcol(\TESTSYS.$DATA14.SPTPCD.PART.P_PARTKEY)
executor_predicates:
(cast(indexcol(\TESTSYS.$DATA14.SPTPCD.PART.P_TYPE)) like
'%BRASS') and (indexcol(\TESTSYS.$DATA14.SPTPCD.PART.P_SIZE) =
15) begin_key: (indexcol(\TESTSYS.$DATA14.SPTPCD.PART.P_PARTKEY)
= -2147483648)
end_key: (indexcol(\TESTSYS.$DATA14.SPTPCD.PART.P_PARTKEY) =
2147483647)
scan_type: file_scan \TESTSYS.$DATA14.SPTPCD.PART PART
scan_direction: forward
key_type: simple
lock_mode: not specified
access_mode: not specified
columns_retrieved: 9
fast_scan: used
fast_replydata_move: used
FILE_SCAN_UNIQUE Operator
DAM Unique Group
The FILE_SCAN_UNIQUE operator describes a portion of an execution plan where
you are scanning for a unique key value. It selects zero or one row.
The FILE_SCAN_UNIQUE operator has no child nodes. The description field for this
operator contains:
Token Followed by ... Data Type
key_columns Columns used as the primary
key
expr(text)
begin_key Expression of the begin key
predicate; same as the end
key predicate
expr(text)
end_key Expression of the end key
predicate; same as the begin
key predicate
expr(text)
scan_type FILE_SCAN_UNIQUE
followed by table name
text