Including Group-By in Query Optimization
Summary: Push group-by past joins to enable early aggregation and potential cost savings. Introduce a greedy conservative heuristic to modify System-R–style optimizers, yielding equal-or-better plans than traditional ones, with extensions to Select-Distinct via cost-based duplicate elimination. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Surajit Chaudhuri (Hewlett Packard Enterprise)
- 2. Kyuseok Shim (Hewlett Packard Enterprise)
BibTeX Citation
@article{chaudhuri_vldb94,
title = {{Including Group-By in Query Optimization}},
author = {Chaudhuri, Surajit and Shim, Kyuseok},
journal = {PVLDB},
series = {{VLDB} '94},
year = {1994}
}Incoming Citations (Sorted by Pagerank)
Showing 9 of 59 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 10,832 | ReSequel: Robust LLM-assisted Query Rewriting and Optimization using Templatization and Sampling | 2026 | VLDB | 4.9793485e-05 |
| 11,258 | Accio: Bolt-on Query Federation | 2025 | VLDB | 4.9793485e-05 |
| 11,617 | Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle | 2024 | VLDB | 4.9793485e-05 |
| 11,777 | Anser: Adaptive Information Sharing Framework of AnalyticDB | 2023 | VLDB | 4.9793485e-05 |
| 11,940 | Synchronization Schemas | 2021 | PODS | 4.9793485e-05 |
| 12,121 | Towards Multi-way Join Aware Optimizer in SAP HANA | 2020 | VLDB | 4.9793485e-05 |
| 12,757 | Database-support for Continuous Prediction Queries over Streaming Data | 2010 | VLDB | 4.9793485e-05 |
| 13,109 | Estimating the Output Cardinality of Partial Preaggregation with a Measure of Clusteredness | 2003 | VLDB | 4.9793485e-05 |
| 13,244 | Partial-Sum Queries in OLAP Data Cubes Using Covering Codes | 1997 | PODS | 4.9793485e-05 |
Outgoing Citations (Sorted by Pagerank)
Showing 10 of 10 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1 | Access Path Selection in a Relational Database Management System | 1979 | SIGMOD | 0.0023947656 |
| 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 |
| 132 | Optimization of Nested SQL Queries Revisited | 1987 | SIGMOD | 0.00030241193 |
| 446 | Query Optimization for Parallel Execution | 1992 | SIGMOD | 0.00018174972 |
| 487 | Randomized Algorithms For Optimizing Large Join Queries | 1990 | SIGMOD | 0.00017462723 |
| 764 | Access Paths in the "Abe" Statistical Query Facility | 1982 | SIGMOD | 0.00014127114 |
| 792 | Parametric Query Optimization | 1992 | VLDB | 0.00013942753 |
| 1,015 | Improved Unnesting Algorithms for Join Aggregate SQL Queries | 1992 | VLDB | 0.00012500439 |
| 1,113 | An Extended Relational Algebra with Control Over Duplicate Elimination | 1982 | PODS | 0.00011971883 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 4,209 | Accelerating Queries with Group-By and Join by Groupjoin | 2011 | VLDB |
| 2 | 5,582 | Efficient Computation of Multiple Group By Queries | 2005 | SIGMOD |
| 3 | 7,907 | A Practical Approach to Groupjoin and Nested Aggregates | 2021 | VLDB |
| 4 | 272 | An Overview of Query Optimization in Relational Systems | 1998 | PODS |
| 5 | 3,595 | A Combined Framework for Grouping and Order Optimization | 2004 | VLDB |
| 6 | 2,516 | Optimization of Queries with User-defined Predicates | 1996 | VLDB |
| 7 | 4,401 | Avoiding Sorting and Grouping In Processing Queries | 2003 | VLDB |
| 8 | 7,344 | SQL Query Optimization: Reordering for a General Class of Queries | 1996 | SIGMOD |
| 9 | 11,617 | Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle | 2024 | VLDB |
| 10 | 2,438 | Groupwise Processing of Relational Queries | 1997 | VLDB |