Database Paper Browser

Back to papers

Enhanced Subquery Optimizations in Oracle

Summary: Oracle enhances subquery optimization with coalescing, window-based removal, and view elimination for group-by queries, reducing redundancies. Introduces parallel execution and a novel antijoin for universal-quantifier subqueries with nulls, showing notable performance gains. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
9893
Venue
VLDB
Year
2009
Pagerank
8.6351917e-05
Overall Rank
2,504 | 82.59%
DOI
-

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 20 of 20 citing papers.

Rank Citing Paper Year Venue Pagerank
2,916 Quantifying TPC-H Choke Points and Their Optimizations 2020 VLDB 7.9068048e-05
3,021 Adaptive and Big Data Scale Parallel Execution in Oracle 2013 VLDB 7.6991391e-05
4,262 Efficient Processing of Window Functions in Analytical SQL Queries 2015 VLDB 6.3117226e-05
4,335 Optimization of Analytic Window Functions 2012 VLDB 6.2790346e-05
4,511 Of Snowstorms and Bushy Trees 2014 VLDB 6.1247645e-05
4,956 Dimensions Based Data Clustering and Zone Maps 2017 VLDB 5.8040891e-05
5,087 Accelerating Queries with Group-By and Join by Groupjoin 2011 VLDB 5.7075009e-05
5,125 The Art of Balance: A RateupDBTM Experience of Building a CPU/GPU Hybrid Database Product 2021 VLDB 5.679423e-05
6,375 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.0923872e-05
6,601 Teaching an RDBMS about ontological constraints 2016 VLDB 4.9972581e-05
6,672 Optimization of Nested Queries using the NF2 Algebra 2016 SIGMOD 4.9669223e-05
7,059 Adaptive and Robust Query Execution for Lakehouses at Scale 2024 VLDB 4.8477825e-05
8,483 Optimization of Common Table Expressions in MPP Database Systems 2015 VLDB 4.5008949e-05
8,680 A Practical Approach to Groupjoin and Nested Aggregates 2021 VLDB 4.4694927e-05
9,989 On the Vexing Difficulty of Evaluating IN Predicates 2026 CIDR 4.1945683e-05
10,412 Query Decorrelation in the Fabric Data Warehouse 2025 SIGMOD 4.1945683e-05
11,023 Window Function Expression: Let the Self-join Enter 2024 VLDB 4.1945683e-05
11,091 Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle 2024 VLDB 4.1945683e-05
11,339 Redundancy Elimination in Distributed Matrix Computation 2022 SIGMOD 4.1945683e-05
11,427 Accelerating Complex Analytics using Speculation 2021 CIDR 4.1945683e-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
51 Including Group-By in Query Optimization 1994 VLDB 0.00067123727
100 Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers 1987 VLDB 0.00049624696
106 Extensible/Rule Based Query Rewrite Optimization in Starburst 1992 SIGMOD 0.00048400734
248 Eager Aggregation and Lazy Aggregation 1995 VLDB 0.00030785339
990 Improved Unnesting Algorithms for Join Aggregate SQL Queries 1992 VLDB 0.00014809094
1,582 Execution Strategies for SQL Subqueries 2007 SIGMOD 0.00011265079
1,869 WinMagic : Subquery Elimination Using Window Aggregation 2003 SIGMOD 0.00010265836
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
454 An Overview of Query Optimization in Relational Systems 1998 PODS 0.00022734812
220 Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans 1998 SIGMOD 0.00033194808
1,451 Extending the Algebraic Framework of Query Processing to Handle Outerjoins 1984 VLDB 0.00011922302
2,044 Optimization of Multi-Way Join Queries for Parallel Execution 1991 VLDB 9.6953608e-05
3,021 Adaptive and Big Data Scale Parallel Execution in Oracle 2013 VLDB 7.6991391e-05
9,662 Efficient Query Re-optimization with Judicious Subquery Selections 2023 SIGMOD 4.3097631e-05
1,476 Efficient Exploitation of Similar Subexpressions for Query Processing 2007 SIGMOD 0.00011779092
639 Orthogonal Optimization of Subqueries and Aggregation 2001 SIGMOD 0.00018791492
1,582 Execution Strategies for SQL Subqueries 2007 SIGMOD 0.00011265079
11,091 Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle 2024 VLDB 4.1945683e-05