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 )