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

Forcing Execution Plans
HP NonStop SQL/MX Query Guide—523728-003
5-6
Using Visual Query Planner to Get the Shape
forward, blocks_per_access 1, mdam off)),partition_access(
scan(path 'SAMDBCAT.PERSNL.JOB', forward, blocks_per_access 1 ,
mdam off))),partition_access(scan(path 'SAMDBCAT.PERSNL.DEPT',
forward, blocks_per_access 1 , mdam off)));
--- SQL operation complete.
Use the additional command, SET SHOWSHAPE, to display the execution plans in
effect. The text format for the shape is displayed immediately before the query output.
If you use the SET SHOWSHAPE command prior to executing the sample query, your
output appears as shown:
control query shape
hybrid_hash_join(hybrid_hash_join(partition_access(
scan(path 'SAMDBCAT.PERSNL.EMPLOYEE',
forward, blocks_per_access 1, mdam off)),partition_access(
scan(path 'SAMDBCAT.PERSNL.JOB', forward, blocks_per_access 1 ,
mdam off))),partition_access(scan(path 'SAMDBCAT.PERSNL.DEPT',
forward, blocks_per_access 1 , mdam off)));
Last Name First Name Mgr Dept/Num Job/Code
-------------------- --------------- ----- -------- --------
WINTER PAUL 43 3100 300
Farley Walt 43 3100 300
Buskett Emmy 43 3100 300
Buskett Paul 43 3100 300
STRICKER GEORGE 43 3100 300
WELLINGTON PETE 43 3100 300
TAYLOR DONALD 43 3100 300
--- 7 row(s) selected.
Using Visual Query Planner to Get the Shape
When you execute a plan with the Visual Query Planner, the text format for shaping
the query can be found by choosing the Show Query Shape option from the Explain
menu. The next figure shows the shape from the sample query.