SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—540440-003
9-55
Considerations for EXPLAIN
OPERATOR CHAR(30) Current node type; one of these:
Operator
CALL
CURSOR_DELETE
CURSOR_UPDATE
ESP_EXCHANGE
EXPLAIN
EXPR
FILE_SCAN
FILE_SCAN_UNIQUE
HASH_GROUPBY
HASH_PARTIAL_GR..._LEAF
HASH_PARTIAL_GR..._ROOT
HYBRID_HASH_JOIN
HYBRID_HASH_SEMI_JOIN
HYBRID_HASH_ANTI_SEMI_JOIN
INDEX_SCAN
INDEX_SCAN_UNIQUE
INSERT
INSERT_VSBB
LEFT_HYBRID_HASH_JOIN
LEFT_MERGE_JOIN
LEFT_NESTED_JOIN
LEFT_ORDERED_HASH_JOIN
MATERIALIZE
MERGE_ANTI_SEMI_JOIN
MERGE_JOIN
MERGE_SEMI_JOIN
MERGE_UNION
NESTED_ANTI_SEMI_JOIN
NESTED_JOIN
NESTED_SEMI_JOIN
ORDERED_HASH_ANTI_SEMI_JOIN
ORDERED_HASH_JOIN
ORDERED_HASH_SEMI_JOIN
PACK
PARTITION_ACCESS
ROOT
SAMPLE
SEQUENCE
SHORTCUT_SCALAR_AGGR
SORT
SORT_GROUPBY
SORT_PARTIAL_AG..._LEAF
SORT_PARTIAL_AG..._ROOT
SORT_PARTIAL_GR..._LEAF
SORT_PARTIAL_GR..._ROOT
SORT_SCALAR_AGGR
SPLIT_TOP
Group (if any)
UDR
DAM unique
DAM unique
Exchange
Stored function
Tuple
DAM subset
DAM unique
Groupby
Groupby
Groupby
Join
Join
Join
DAM subset
DAM unique
Insert
Insert
Join
Join
Join
Join
Materialize
Join
Join
Join
Merge union
Join
Join
Join
Join
Join
Join
Rowset
Exchange
Root
Data mining
Data mining
Groupby
Sort
Groupby
Groupby
Groupby
Groupby
Groupby
Groupby
Exchange
Column Name Data Type Description