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

Operators and Operator Groups
HP NonStop SQL/MX Query Guide—523728-003
7-9
FILE_SCAN Operator
The FILE_SCAN operator has no child nodes. The description field for this operator
contains:
The example of the FILE_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)
Token Followed by ... Data Type
begin_key Expression of the begin key
predicates
expr(text)
end_key Expression of the end key
predicates
expr(text)
scan_type FILE_SCAN followed by
table name
text
scan_direction Forward or reverse text
lock_mode No lock, share lock, or
exclusive lock
text
access_mode Read committed, read
uncommitted, or serializable
text
executor_predicates Any predicate expression
that is not a key predicate
expr(text)
key_columns Columns used as the
primary key
expr(text)
key_type Simple or MDAM text
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