Optimizing multi-table queries
Overview
To optimize a query block that joins n tables:
Start with a plan for each table
- For every table in the query block, find the best plan that
includes conditions on the table's columns, (excluding joins).
- Push down selects and projects.
|