Derby's cost-based optimization

The query optimizer makes cost-based decisions to determine:
Related concepts
Index use and access paths
Joins and performance