Query Optimizer Phases
The SQL Server Query Optimizer uses cost-based optimization to create an execution plan with the least cost.
Query Tuning
Opportunities for Query Optimization
Optimize your SQL Server queries for maximum performance. Learn how to troubleshoot query plans and identify optimization opportunities.