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

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-37
CONTROL QUERY SHAPE Statement
statement can still contain additional enforcer nodes, and the compiler will
enforce such nodes. Note that WITHOUT ENFORCERS does not mean that
the statement or the generated plans are free of enforcer nodes.
shape
specifies the operator tree for an access plan for the next query to be executed
within the current session. shape defines this operator tree recursively by using a
LISP-like expression to represent the nodes of the tree.
The identifiers for the nodes specified by shape:
CUT
ANYTHING
OFF
Replaces a node in operator tree. CUT (or ANYTHING or
OFF) represents the point (node) at which you want to cut off
the remaining part of the operator tree.
TUPLE Replaces a single VALUES node in operator tree.
UNION Replaces a UNION node in operator tree.
GROUPBY Replaces a GROUP BY or AGGREGATE (set) operation
node in operator tree.
SORT_GROUPBY Replaces a SORT GROUP BY or AGGREGATE (set)
operation node in operator tree.
HASH_GROUPBY(cut)
or HG (cut)
Replaces a HASH GROUP BY node in operator tree.
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.