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

Operators and Operator Groups
HP NonStop SQL/MX Query Guide—523728-003
7-11
FILE_SCAN_UNIQUE Operator
The example of the FILE_SCAN_UNIQUE 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
key_type Simple or MDAM text
lock_mode No lock, share lock, or
exclusive lock
text
access_mode Read committed, read
uncommitted, or serializable
text
columns_retrieved Estimate of the number of
columns to be returned
integer
executor_predicates Expression of the nonkey
predicates
expr(text)
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
olt_optimization An indicator that shows
whether an optimization for
short, simple operations is
used. The value used is
returned if this optimization is
used.
text
Token Followed by ... Data Type