SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
9-65
Considerations for EXPLAIN
Operator
CALL
CURSOR_DELETE
CURSOR_UPDATE
ESP_ACCESS
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
NextValueFor
ORDERED_HASH_ANTI_SEMI_JOIN
ORDERED_HASH_JOIN
ORDERED_HASH_SEMI_JOIN
PACK
PARTITION_ACCESS
ROOT
SAMPLE
SEQUENCE
Sequence Generator
SHORTCUT_SCALAR_AGGR
SORT
SORT_GROUPBY
Group (if any)
UDR
DAM unique
DAM unique
Sequence
Generator
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
Sequence
Generator
Join
Join
Join
Rowset
Exchange
Root
Data mining
Data mining
Sequence
Generator
Groupby
Sort
Groupby
Column Name Data Type Description