SQL/MX 3.2.1 Query Guide (H06.26+, J06.15+)

SQL/MX Operators
HP NonStop SQL/MX Release 3.2.1 Query Guide—663851-003
7-65
SEQUENCE Operator
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.
The SEQUENCE operator has one child node. The description field for this operator
contains the following:
Token Followed by ... Data Type
fragment_id A sequential number assigned to the fragment.
0 is always the master executor and 1 is
reserved for the EXPLAIN plan. Numbers 2 to
n will be ESP or DAM fragments.
integer
parent_frag The fragment_id for the parent of the current
fragment. The value is (none) for the master
executor.
integer
fragment_type Master, ESP, or DP2. text
required_order List of column references specifying the
ordering required by the SEQUENCE operator.
Obtained from a list of columns specified in the
SEQUENCE BY clause.
expr(text)
TP663851.fm Page 65 Wednesday, January 30, 2013 5:37 PM