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

SQL/MX Operators
HP NonStop SQL/MX Query Guide—540437-005
7-17
FILE_SCAN_UNIQUE Operator
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 ........... 10
parent_frag ............ 0
fragment_type .......... dp2
olt_optimization ....... not used
olt_opt_lean ........... not used
scan_type .............. subset scan of table
DETCAT.DETSCH.PARTSUPP PS1
scan_direction ......... forward
key_type ............... simple
lock_mode .............. not specified, defaulted to lock
cursor
access_mode ............ not specified, defaulted to read
committed
columns_retrieved ...... 5
fast_scan .............. used
fast_replydata_move .... used
key_columns ............ PS_PARTKEY, PS_SUPPKEY
begin_key .............. (PS_PARTKEY =
DETCAT.DETSCH.PSX1.PS_PARTKEY),
PS_SUPPKEY = <min>)
end_key ................ (PS_PARTKEY =
DETCAT.DETSCH.PSX1.PS_PARTKEY),
(PS_SUPPKEY = <max>)
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.