[prev] 73 [next]

Approaches to Optimisation (cont)

Example of optimisation transformations:

[Diagram:Pics/qproc/query-transform.png]


For join, may also consider sort/merge join and hash join.