Class | Description |
---|---|
NestedLoop |
Plan that will be executed with the awesome nested loop algorithm
performing CROSS JOINs
This Plan makes a lot of assumptions:
limit and offset are already pushed down to left and right plan nodes
where clause is already splitted to left and right plan nodes
order by symbols are already splitted, too
if the first order by symbol in the whole statement is from the left node,
set
leftOuterLoop to true, otherwise to false
Properties:
the resulting outputs from the join operations are the same, no matter if
leftOuterLoop is true or not - so the projections added,
can assume the same order of symbols, first symbols from left, then from right. |
NestedLoopPhase |