DBScholar

Back to papers

Enhanced Subquery Optimizations in Oracle

Summary: Oracle’s optimizer removes subquery redundancies via coalescing, window-function rewrites, and GROUP BY view elimination. It adds scalable parallel execution and a null-aware antijoin for universal-quantifier queries, yielding substantial speedups. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID
hca922ae85e707d88
Venue
VLDB
Year
2009
Pagerank
9.0230202e-05
Overall Rank
2,109 | 85.83%
DOI
10.14778/1687553.1687563

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{bellamkonda_vldb09,
        title = {{Enhanced Subquery Optimizations in Oracle}},
        author = {Bellamkonda, Srikanth and Ahmed, Rafi and Witkowski, Andrew and Amor, Angela and Zait, Mohamed and Lin, Chun-Chieh},
        journal = {PVLDB},
        series = {{VLDB} '09},
        doi = {10.14778/1687553.1687563},
        url = {https://doi.org/10.14778/1687553.1687563},
        year = {2009}
}

Incoming Citations (Sorted by Pagerank)

Showing 20 of 20 citing papers.

Rank Citing Paper Year Venue Pagerank
1,949 Quantifying TPC-H Choke Points and Their Optimizations 2020 VLDB 9.3172855e-05
2,529 Adaptive and Big Data Scale Parallel Execution in Oracle 2013 VLDB 8.3361013e-05
3,427 Efficient Processing of Window Functions in Analytical SQL Queries 2015 VLDB 7.3048595e-05
3,763 Dimensions Based Data Clustering and Zone Maps 2017 VLDB 7.0389893e-05
3,834 Optimization of Analytic Window Functions 2012 VLDB 6.9910267e-05
4,052 Of Snowstorms and Bushy Trees 2014 VLDB 6.8257821e-05
4,138 The Art of Balance: A RateupDB Experience of Building a CPU/GPU Hybrid Database Product 2021 VLDB 6.782996e-05
4,209 Accelerating Queries with Group-By and Join by Groupjoin 2011 VLDB 6.7307652e-05
5,354 Adaptive and Robust Query Execution for Lakehouses at Scale 2024 VLDB 6.1661231e-05
6,086 Dear User-Defined Functions, Inlining isn't working out so great for us. Let's try batching to make our relationship work. Sincerely, SQL 2024 CIDR 5.8893767e-05
6,762 Teaching an RDBMS about ontological constraints 2016 VLDB 5.6873437e-05
7,300 Optimization of Nested Queries using the NF2 Algebra 2016 SIGMOD 5.5594746e-05
7,911 A Practical Approach to Groupjoin and Nested Aggregates 2021 VLDB 5.4261869e-05
8,660 Optimization of Common Table Expressions in MPP Database Systems 2015 VLDB 5.2919676e-05
9,659 Window Function Expression: Let the Self-join Enter 2024 VLDB 5.142891e-05
10,369 On the Vexing Difficulty of Evaluating IN Predicates 2026 CIDR 4.9769913e-05
11,140 Query Decorrelation in the Fabric Data Warehouse 2025 SIGMOD 4.9769913e-05
11,623 Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle 2024 VLDB 4.9769913e-05
11,852 Redundancy Elimination in Distributed Matrix Computation 2022 SIGMOD 4.9769913e-05
11,938 Accelerating Complex Analytics using Speculation 2021 CIDR 4.9769913e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 7 of 7 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
73 Including Group-By in Query Optimization 1994 VLDB 0.0003750677
97 Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers 1987 VLDB 0.00034111286
109 Extensible/Rule Based Query Rewrite Optimization in Starburst 1992 SIGMOD 0.00032757423
213 Eager Aggregation and Lazy Aggregation 1995 VLDB 0.00024753576
1,015 Improved Unnesting Algorithms for Join Aggregate SQL Queries 1992 VLDB 0.00012495751
1,378 Execution Strategies for SQL Subqueries 2007 SIGMOD 0.00010859556
2,047 WinMagic : Subquery Elimination Using Window Aggregation 2003 SIGMOD 9.1286561e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 272 An Overview of Query Optimization in Relational Systems 1998 PODS
2 149 Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans 1998 SIGMOD
3 1,936 Extending the Algebraic Framework of Query Processing to Handle Outerjoins 1984 VLDB
4 2,138 Optimization of Multi-Way Join Queries for Parallel Execution 1991 VLDB
5 2,529 Adaptive and Big Data Scale Parallel Execution in Oracle 2013 VLDB
6 8,170 Efficient Query Re-optimization with Judicious Subquery Selections 2023 SIGMOD
7 1,132 Efficient Exploitation of Similar Subexpressions for Query Processing 2007 SIGMOD
8 552 Orthogonal Optimization of Subqueries and Aggregation 2001 SIGMOD
9 1,378 Execution Strategies for SQL Subqueries 2007 SIGMOD
10 11,623 Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle 2024 VLDB