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.0272361e-05
Overall Rank
2,108 | 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,952 Quantifying TPC-H Choke Points and Their Optimizations 2020 VLDB 9.3189525e-05
2,530 Adaptive and Big Data Scale Parallel Execution in Oracle 2013 VLDB 8.3391175e-05
3,427 Efficient Processing of Window Functions in Analytical SQL Queries 2015 VLDB 7.3082914e-05
3,762 Dimensions Based Data Clustering and Zone Maps 2017 VLDB 7.0421949e-05
3,833 Optimization of Analytic Window Functions 2012 VLDB 6.9942782e-05
4,052 Of Snowstorms and Bushy Trees 2014 VLDB 6.8283077e-05
4,137 The Art of Balance: A RateupDB Experience of Building a CPU/GPU Hybrid Database Product 2021 VLDB 6.7861661e-05
4,209 Accelerating Queries with Group-By and Join by Groupjoin 2011 VLDB 6.7339503e-05
5,348 Adaptive and Robust Query Execution for Lakehouses at Scale 2024 VLDB 6.1690434e-05
6,085 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.892166e-05
6,757 Teaching an RDBMS about ontological constraints 2016 VLDB 5.6900373e-05
7,296 Optimization of Nested Queries using the NF2 Algebra 2016 SIGMOD 5.5621076e-05
7,907 A Practical Approach to Groupjoin and Nested Aggregates 2021 VLDB 5.4287568e-05
8,652 Optimization of Common Table Expressions in MPP Database Systems 2015 VLDB 5.2944739e-05
9,652 Window Function Expression: Let the Self-join Enter 2024 VLDB 5.1453267e-05
10,357 On the Vexing Difficulty of Evaluating IN Predicates 2026 CIDR 4.9793485e-05
11,131 Query Decorrelation in the Fabric Data Warehouse 2025 SIGMOD 4.9793485e-05
11,617 Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle 2024 VLDB 4.9793485e-05
11,846 Redundancy Elimination in Distributed Matrix Computation 2022 SIGMOD 4.9793485e-05
11,932 Accelerating Complex Analytics using Speculation 2021 CIDR 4.9793485e-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.00037522101
97 Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers 1987 VLDB 0.00034124569
109 Extensible/Rule Based Query Rewrite Optimization in Starburst 1992 SIGMOD 0.0003276959
213 Eager Aggregation and Lazy Aggregation 1995 VLDB 0.00024759805
1,015 Improved Unnesting Algorithms for Join Aggregate SQL Queries 1992 VLDB 0.00012500439
1,378 Execution Strategies for SQL Subqueries 2007 SIGMOD 0.00010864448
2,045 WinMagic : Subquery Elimination Using Window Aggregation 2003 SIGMOD 9.1329128e-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,935 Extending the Algebraic Framework of Query Processing to Handle Outerjoins 1984 VLDB
4 2,136 Optimization of Multi-Way Join Queries for Parallel Execution 1991 VLDB
5 2,530 Adaptive and Big Data Scale Parallel Execution in Oracle 2013 VLDB
6 8,164 Efficient Query Re-optimization with Judicious Subquery Selections 2023 SIGMOD
7 1,131 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,617 Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle 2024 VLDB