SQL/MX 3.1 Query Guide (H06.23+, J06.12+)

SQL/MX Operators
HP NonStop SQL/MX Release 3.1 Query Guide—663851-001
7-63
SEQUENCE Operator
The following is an example of the SAMPLE_FILE_SCAN operator:
PREPARE TestQuery22 FROM
select * from tt22 sample random 10 percent;
DESCRIPTION
fragment_id ............ 2
parent_frag ............ 0
fragment_type .......... dp2
olt_optimization ....... not used
olt_opt_lean ........... not used
scan_type .............. sample full scan of table
DETCAT.DETSCH.TT22
scan_direction ......... forward
key_type ............... simple
lock_mode .............. not specified, defaulted to lock
cursor
access_mode ............ not specified, defaulted to read
committed
columns_retrieved ...... 2
fast_replydata_move .... used
key_columns ............ F1
begin_key .............. (F1 = <min>)
end_key .................. (F1 = <max>)
SEQUENCE Operator
Data Mining Group
The SEQUENCE operator occurs as a result of a SEQUENCE BY clause in the query.
key_columns Columns used as the primary key. expr(text)
executor_predicates Any predicate expression that is not a key
predicate evaluated by the executor in DAM.
expr(text)
mdam_disjunct Disjunct key predicates used by MDAM expr(text)
part_key_predicate Predicate expression specified on partitioning
key. It is displayed only if partitioning key
differs from clustering key.
expr(text)
begin_key Expression of the begin key predicate. expr(text)
end_key Expression of the end key predicate. expr(text)
key_type Simple or MDAM. text
TP663851.fm Page 63 Monday, October 17, 2011 11:48 AM