SQL/MX 3.1 Query Guide (H06.23+, J06.12+)

Forcing Execution Plans
HP NonStop SQL/MX Release 3.1 Query Guide—663851-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.
TP663851.fm Page 17 Monday, October 17, 2011 11:48 AM