Manualshelf

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

ManualsBrandsHP ManualsServerHP NonStop G-Series
101102103104105106107108109110
Forcing Execution Plans
HP NonStop SQL/MX Query Guide—523728-003
5-17
Forcing Parallel Plans
This statement enables the optimizer to add exchange nodes:
CONTROL QUERY SHAPE IMPLICIT EXCHANGE
HYBRID_HASH_JOIN (
SCAN('DEPT'),
SCAN('EMP'),
TYPE2);
For syntax and more information, see the SQL/MX Reference Manual.