I started a series of articles concerning the cost of queries (and as a consequence concerning the choices the optimizer makes).
This post is a index of these articles.
1 – DB2 : Cost calculations 1 : Table Scan
2 – DB2 : Cost Calculations 2 : Index Only
3 – DB2 : Cost Calculations 3 : index only revisited