SQL/MX 2.x Query Guide (G06.24+, H06.03+)

Forcing Execution Plans
HP NonStop SQL/MX Query Guide—523728-003
5-7
Manually Writing the Shape
You can make changes to the shape and then force a new shape by selecting the Get
Shape icon (the middle icon in the upper left corner). In addition, from the Explain
menu, you must execute Get Explain Plan to see the revised plan.
For more information about the SHOWSHAPE and SET SHOWSHAPE commands,
see the SQL/MX Reference Manual. For more information about using the Visual
Query Planner, see Section 4, Reviewing Query Execution Plans. The Visual Query
Planner online help system also provides useful information.
Manually Writing the Shape
You translate the tree by recursively writing the tree with this rule (starting from the
root):
TEXT (node) = node-identifier + '(' + TEXT(child1) + ',' +
TEXT(child2) + ... + ')'
node Operator tree node being transformed
node-identifier Identifier of the node.
child i The ith child, if any, from left to right
vst602.vsd