Execution strategies for SQL subqueries

The basic building blocks that Microsoft SQL Server utilizes to optimize and execute relational subqueries are explored and it is shown that indeed alternative execution strategies are needed in different circumstances, which make a cost-based query optimizer indispensable for adequate query performance.