The query optimizer makes cost-based decisions to determine:
- Which index (if any) to use on each table in a query (see )
- The join order (see )
- The join strategy (see )
- Whether to avoid additional sorting (see )
- Automatic lock escalation (see )
- Whether to use bulk fetch (see )