Execution Strategies for SQL Subqueries
Summary: Examines SQL Server's subquery optimization: correlation removal and a suite of strategies (forward/reverse lookup, set-based). Experiments show different strategies suit different cases, novel approaches not published before, underscoring cost-based optimization. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Mostafa Elhemali (Microsoft)
- 2. César A. Galindo-Legaria (Microsoft)
- 3. Torsten Grabs (Microsoft)
- 4. Milind M. Joshi (Microsoft)
BibTeX Citation
@inproceedings{elhemali_sigmod07,
title = {{Execution Strategies for SQL Subqueries}},
author = {Elhemali, Mostafa and Galindo-Legaria, César A. and Grabs, Torsten and Joshi, Milind M.},
series = {{SIGMOD} '07},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/1247480.1247598},
url = {https://dl.acm.org/doi/10.1145/1247480.1247598},
year = {2007}
}Incoming Citations (Sorted by Pagerank)
Showing 25 of 25 citing papers.
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 6 of 6 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 132 | Optimization of Nested SQL Queries Revisited | 1987 | SIGMOD | 0.00030241193 |
| 552 | Orthogonal Optimization of Subqueries and Aggregation | 2001 | SIGMOD | 0.0001653835 |
| 821 | Query Execution Techniques for Caching Expensive Methods | 1996 | SIGMOD | 0.00013660347 |
| 1,015 | Improved Unnesting Algorithms for Join Aggregate SQL Queries | 1992 | VLDB | 0.00012500439 |
| 4,390 | On Semantic Reefs and Efficient Processing of Correlation Queries with Aggregates | 1985 | VLDB | 6.6221941e-05 |
| 6,055 | Translating and Optimizing SQL Queries Having Aggregates | 1987 | VLDB | 5.9018319e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 2,136 | Optimization of Multi-Way Join Queries for Parallel Execution | 1991 | VLDB |
| 2 | 8,164 | Efficient Query Re-optimization with Judicious Subquery Selections | 2023 | SIGMOD |
| 3 | 2,438 | Groupwise Processing of Relational Queries | 1997 | VLDB |
| 4 | 149 | Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans | 1998 | SIGMOD |
| 5 | 646 | Exploiting Statistics on Query Expressions for Optimization | 2002 | SIGMOD |
| 6 | 272 | An Overview of Query Optimization in Relational Systems | 1998 | PODS |
| 7 | 2,108 | Enhanced Subquery Optimizations in Oracle | 2009 | VLDB |
| 8 | 13,017 | A Nested Relational Approach to Processing SQL Subqueries | 2005 | SIGMOD |
| 9 | 552 | Orthogonal Optimization of Subqueries and Aggregation | 2001 | SIGMOD |
| 10 | 1,131 | Efficient Exploitation of Similar Subexpressions for Query Processing | 2007 | SIGMOD |