Orthogonal optimization of subqueries and aggregation

This paper describes techniques implemented in Microsoft SQL Server for queries containing sub-queries and/or aggregations, based on a number of orthogonal optimizations, and focuses separately on removing correlated subqueries, also called “query flattening,” and on efficient execution of queries with aggregations.