|< < 36 > >|

Optimizing multi-table queries

Extending a plan

Example

2) Join S using Index Nested Loops on S(rid)

Use the index on S(rid).
IndexNestedLoops( SelectScan( TableScan(R), a > 100), SelectScan( SelectIndex(S(rid), S.rid = OUTERLOOP.rid), b = 1))

|< < 36 > >|