Mediator Cost Model
The Mediator has a generic cost model :
- Unary Operators :
- sequential scan and index scan
- cost formulae derived using calibrating approach
- Binary Operators :
- index join, nested loops and sort-merge join
- if index is available, index join is chosen, otherwise the best of the other two
Wrapper can override the mediator model by exporting statistics and/or cost formulae.