Query Optimizer Phases
The SQL Server Query Optimizer uses cost-based optimization to create an execution plan with the least cost.
Relational Engine
The SQL Server Database Engine
Explore the SQL Server Database Engine and its key components: SQLOS, Relational Engine, and Storage Engine.