Why Do Flocks?
Flock plan appears more complex:
- 7 queries (only 1 in direct)
- final join of 5 relations (4 in direct)
However
- first 6 queries are simple
- final join is faster
- smaller relations (base relation reductions)
- smaller intermediate results (auxiliary relations)