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

Compiling and Executing a Query
HP NonStop SQL/MX Query Guide—523728-003
1-15
How the Executor Processes the Plan
Concurrent or overlapping work can be performed on rows as they flow through the
different stages of the execution plan. For example, while the left child of a nested-loop
join is working on producing more rows or waiting for a reply from a DAM process, the
right child can be working on obtaining matches on the rows already produced by the
left child. For more information about parallelism, see Section 8, Parallelism.