|< < 34 > >|

Optimizing multi-table queries

Extending a plan

Example

Best plan for R

No index on R(a), so scan the table and check the condition.
SelectScan( TableScan(R), a > 100)

|< < 34 > >|