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
9894
Venue
VLDB
Year
2009
Pagerank
8.6306662e-05
Overall Rank
2,503 | 82.61%
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,914 Quantifying TPC-H Choke Points and Their Optimizations 2020 VLDB 7.9197583e-05
3,016 Adaptive and Big Data Scale Parallel Execution in Oracle 2013 VLDB 7.7060968e-05
4,257 Efficient Processing of Window Functions in Analytical SQL Queries 2015 VLDB 6.3050642e-05
4,329 Optimization of Analytic Window Functions 2012 VLDB 6.2746513e-05
4,503 Of Snowstorms and Bushy Trees 2014 VLDB 6.131076e-05
4,954 Dimensions Based Data Clustering and Zone Maps 2017 VLDB 5.8058349e-05
5,087 Accelerating Queries with Group-By and Join by Groupjoin 2011 VLDB 5.7032118e-05
5,129 The Art of Balance: A RateupDBTM Experience of Building a CPU/GPU Hybrid Database Product 2021 VLDB 5.6724875e-05
6,374 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.0874998e-05
6,602 Teaching an RDBMS about ontological constraints 2016 VLDB 4.9924633e-05
6,672 Optimization of Nested Queries using the NF2 Algebra 2016 SIGMOD 4.9621566e-05
6,683 Adaptive and Robust Query Execution for Lakehouses at Scale 2024 VLDB 4.9593505e-05
8,482 Optimization of Common Table Expressions in MPP Database Systems 2015 VLDB 4.4965793e-05
8,676 A Practical Approach to Groupjoin and Nested Aggregates 2021 VLDB 4.4652082e-05
9,988 On the Vexing Difficulty of Evaluating IN Predicates 2026 CIDR 4.1905499e-05
10,423 Query Decorrelation in the Fabric Data Warehouse 2025 SIGMOD 4.1905499e-05
11,026 Window Function Expression: Let the Self-join Enter 2024 VLDB 4.1905499e-05
11,094 Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle 2024 VLDB 4.1905499e-05
11,341 Redundancy Elimination in Distributed Matrix Computation 2022 SIGMOD 4.1905499e-05
11,430 Accelerating Complex Analytics using Speculation 2021 CIDR 4.1905499e-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.00067060283
102 Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers 1987 VLDB 0.00049592627
107 Extensible/Rule Based Query Rewrite Optimization in Starburst 1992 SIGMOD 0.00048363446
249 Eager Aggregation and Lazy Aggregation 1995 VLDB 0.00030773137
991 Improved Unnesting Algorithms for Join Aggregate SQL Queries 1992 VLDB 0.00014797083
1,581 Execution Strategies for SQL Subqueries 2007 SIGMOD 0.00011262795
1,871 WinMagic : Subquery Elimination Using Window Aggregation 2003 SIGMOD 0.0001025746
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.00022796106
221 Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans 1998 SIGMOD 0.00033182072
1,455 Extending the Algebraic Framework of Query Processing to Handle Outerjoins 1984 VLDB 0.00011912375
2,051 Optimization of Multi-Way Join Queries for Parallel Execution 1991 VLDB 9.6871984e-05
3,016 Adaptive and Big Data Scale Parallel Execution in Oracle 2013 VLDB 7.7060968e-05
9,662 Efficient Query Re-optimization with Judicious Subquery Selections 2023 SIGMOD 4.3056334e-05
1,475 Efficient Exploitation of Similar Subexpressions for Query Processing 2007 SIGMOD 0.00011765071
640 Orthogonal Optimization of Subqueries and Aggregation 2001 SIGMOD 0.00018780632
1,581 Execution Strategies for SQL Subqueries 2007 SIGMOD 0.00011262795
11,094 Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle 2024 VLDB 4.1905499e-05