Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle

Summary: Oracle extends group-before-join rewriting with aggregate decomposition, increasing applicable rewrite candidates. It adds view/subquery subsumption for shared computation and union-all duplication for disjunctive joins, enabling early pruning and avoiding redundant accesses and joins. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID: 13806
Venue: VLDB
Year: 2024
Pagerank: 5.093636e-05
Overall Rank: 11,297 | 22.50%
DOI: 10.14778/3685800.3685837

Incoming Non-self Citations Over Time

No non-self incoming citations found for this paper in this database.

Authors

1. Rafi Ahmed (Oracle)
2. Krishna Kantikiran Pasupuleti (Oracle)
3. Sriram Tirupattur (Oracle)
4. Lei Sheng (Oracle)
5. Hong Su (Oracle)
6. Mohamed Ziauddin (Oracle)

BibTeX Citation

@article{ahmed_vldb24,
        title = {{Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle}},
        author = {Ahmed, Rafi and Pasupuleti, Krishna Kantikiran and Tirupattur, Sriram and Sheng, Lei and Su, Hong and Ziauddin, Mohamed},
        journal = {PVLDB},
        series = {{VLDB} '24},
        volume = {17},
        number = {12},
        pages = {4200--4212},
        doi = {10.14778/3685800.3685837},
        url = {https://doi.org/10.14778/3685800.3685837},
        year = {2024}
}

Incoming Citations (Sorted by Pagerank)

Showing 0 of 0 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank

Outgoing Citations (Sorted by Pagerank)

Showing 15 of 15 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
71	Including Group-By in Query Optimization	1994	VLDB	0.00038021159
110	Extensible/Rule Based Query Rewrite Optimization in Starburst	1992	SIGMOD	0.0003309592
153	Common Expression Analysis in Database Applications	1982	SIGMOD	0.00029032276
198	Aggregate-Query Processing in Data Warehousing Environments	1995	VLDB	0.00025618616
206	Eager Aggregation and Lazy Aggregation	1995	VLDB	0.00025092273
869	Rewriting Aggregate Queries Using Views	1999	PODS	0.00013503594
1,154	Efficient Exploitation of Similar Subexpressions for Query Processing	2007	SIGMOD	0.00011934202
1,687	Spreadsheets in RDBMS for OLAP	2003	SIGMOD	0.00010005718
2,095	Enhanced Subquery Optimizations in Oracle	2009	VLDB	9.1803718e-05
2,238	Deciding Equivalences among Aggregate Queries	1998	PODS	8.8882317e-05
4,091	Of Snowstorms and Bushy Trees	2014	VLDB	6.9090244e-05
4,101	Automated Generation of Materialized Views in Oracle	2020	VLDB	6.9009734e-05
4,223	Accelerating Queries with Group-By and Join by Groupjoin	2011	VLDB	6.8224393e-05
4,416	Query Optimization in Oracle 12c Database In-Memory	2015	VLDB	6.7150543e-05
8,893	Optimizing Disjunctive Queries with Tagged Execution	2024	SIGMOD	5.3504579e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	2,664	Adaptive and Big Data Scale Parallel Execution in Oracle	2013	VLDB
2	7,272	SQL Query Optimization: Reordering for a General Class of Queries	1996	SIGMOD
3	9,756	Efficient Query Re-optimization with Judicious Subquery Selections	2023	SIGMOD
4	4,223	Accelerating Queries with Group-By and Join by Groupjoin	2011	VLDB
5	7,020	The Generalized Pre-Grouping Transformation: Aggregate Query Optimization in the Presence of Dependencies	2003	VLDB
6	543	Orthogonal Optimization of Subqueries and Aggregation	2001	SIGMOD
7	7,787	A Practical Approach to Groupjoin and Nested Aggregates	2021	VLDB
8	2,385	Groupwise Processing of Relational Queries	1997	VLDB
9	71	Including Group-By in Query Optimization	1994	VLDB
10	2,095	Enhanced Subquery Optimizations in Oracle	2009	VLDB