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
8.9938885e-05
Overall Rank
2,122 | 85.78%
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,958 Quantifying TPC-H Choke Points and Their Optimizations 2020 VLDB 9.2894133e-05
2,527 Adaptive and Big Data Scale Parallel Execution in Oracle 2013 VLDB 8.3243069e-05
3,438 Efficient Processing of Window Functions in Analytical SQL Queries 2015 VLDB 7.2807703e-05
3,766 Dimensions Based Data Clustering and Zone Maps 2017 VLDB 7.0177057e-05
3,842 Optimization of Analytic Window Functions 2012 VLDB 6.968919e-05
4,048 Of Snowstorms and Bushy Trees 2014 VLDB 6.817438e-05
4,063 The Art of Balance: A RateupDB Experience of Building a CPU/GPU Hybrid Database Product 2021 VLDB 6.812902e-05
4,227 Accelerating Queries with Group-By and Join by Groupjoin 2011 VLDB 6.7087461e-05
5,367 Adaptive and Robust Query Execution for Lakehouses at Scale 2024 VLDB 6.1462017e-05
6,100 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.8699028e-05
6,781 Teaching an RDBMS about ontological constraints 2016 VLDB 5.6685378e-05
7,319 Optimization of Nested Queries using the NF2 Algebra 2016 SIGMOD 5.5410915e-05
7,927 A Practical Approach to Groupjoin and Nested Aggregates 2021 VLDB 5.4082473e-05
8,678 Optimization of Common Table Expressions in MPP Database Systems 2015 VLDB 5.2744774e-05
9,687 Window Function Expression: Let the Self-join Enter 2024 VLDB 5.1258854e-05
10,436 On the Vexing Difficulty of Evaluating IN Predicates 2026 CIDR 4.9605343e-05
11,199 Query Decorrelation in the Fabric Data Warehouse 2025 SIGMOD 4.9605343e-05
11,670 Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle 2024 VLDB 4.9605343e-05
11,896 Redundancy Elimination in Distributed Matrix Computation 2022 SIGMOD 4.9605343e-05
11,982 Accelerating Complex Analytics using Speculation 2021 CIDR 4.9605343e-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.00037420958
99 Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers 1987 VLDB 0.00034024478
109 Extensible/Rule Based Query Rewrite Optimization in Starburst 1992 SIGMOD 0.00032702871
213 Eager Aggregation and Lazy Aggregation 1995 VLDB 0.00024695393
1,015 Improved Unnesting Algorithms for Join Aggregate SQL Queries 1992 VLDB 0.00012468327
1,381 Execution Strategies for SQL Subqueries 2007 SIGMOD 0.00010832197
2,054 WinMagic : Subquery Elimination Using Window Aggregation 2003 SIGMOD 9.1030561e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 259 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,945 Extending the Algebraic Framework of Query Processing to Handle Outerjoins 1984 VLDB
4 2,151 Optimization of Multi-Way Join Queries for Parallel Execution 1991 VLDB
5 2,527 Adaptive and Big Data Scale Parallel Execution in Oracle 2013 VLDB
6 8,188 Efficient Query Re-optimization with Judicious Subquery Selections 2023 SIGMOD
7 1,137 Efficient Exploitation of Similar Subexpressions for Query Processing 2007 SIGMOD
8 554 Orthogonal Optimization of Subqueries and Aggregation 2001 SIGMOD
9 1,381 Execution Strategies for SQL Subqueries 2007 SIGMOD
10 11,670 Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle 2024 VLDB