The Cost of Execution
Costs very important to the optimizer
- It must search for low-cost query execution plan
- Statistics:
- Cardinalities
- Histograms (estimate selectivities)
- Impact of data integration?
I/O vs. computation costs
Time-to-first-tuple vs. completion time