|< < 35 > >|

Optimizing multi-table queries

Extending a plan

Example

Include the join with S (no other choice).

How should the join be done?

1) Join S using Block Nested Loops

Push down both predicates on S.
BlockNestedLoops( SelectScan( TableScan(R), a > 100), SelectScan( TableScan(S), S.rid = OUTERLOOP.rid and S.b = 1))