The SQL Server Query Optimizer uses cost-based optimization to create an execution plan with the least cost.