|< < 37 > >|

Optimizing multi-table queries

Extending a plan

Example

3) Join S using Index Nested Loops on S(b)

Same idea, but use the other index.
IndexNestedLoops( SelectScan( TableScan(R), a > 100), SelectScan( SelectIndex(S(b), S.b = 1), S.rid = OUTERLOOP.rid))

|< < 37 > >|