Manualshelf

SQL/MX 3.x Query Guide (H06.22+, J06.11+)

ManualsBrandsHP ManualsServerHP Integrity NonStop H-Series
111112113114115116117118119120
Forcing Execution Plans
HP NonStop SQL/MX Query Guide—640323-001
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.