SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—544517-008
2-39
CONTROL QUERY SHAPE Statement
SHORTCUT_GROUPBY Replaces an AGGREGATE (set) operation node in operator
tree.
EXPR Replaces a map value IDs node in operator tree.
SORT Replaces a SORT node in operator tree.
EXCHANGE Replaces any of three nodes—PARTITION ACCESS, SPLIT
TOP / PARTITION ACCESS, and REPARTITION—in
operator tree.
PARTITION_ACCESS Replaces a PARTITION ACCESS node in operator tree.
SPLIT_TOP_PA Replaces a SPLIT TOP / PARTITION ACCESS node pair in
operator tree.
ESP_EXCHANGE Replaces an ESP_EXCHANGE node in operator tree.
MATERIALIZE Replaces a materialized temporary table node in operator
tree.
PACK Optionally replaces a PACK node in operator tree. This
node relates to rowsets.
UNPACK Optionally replaces an UNPACK node in operator tree. This
node relates to rowsets.
SCAN Replaces a SCAN node in operator tree.
FILE_SCAN Replaces a SCAN node in operator tree.
INDEX_SCAN Replaces a SCAN node in operator tree.
JOIN Replaces a JOIN node in operator tree.
NESTED_JOIN Replaces a NESTED_JOIN in operator tree.
MERGE_JOIN Replaces a MERGE_JOIN in operator tree.
HASH_JOIN (cut,cut) or
HJ (cut,cut)
Replaces a HYBRID_HASH_JOIN or
ORDERED_HASH_JOIN in operator tree.
HYBRID_HASH_JOIN
(cut,cut) or HHJ (cut,cut)
Replaces a HYBRID_HASH_JOIN in operator tree.
ORDERED_HASH_JOIN
(cut,cut) or OHJ
(cut,cut)
Replaces an ORDERED_HASH_JOIN in operator tree.