Performing Group-By before Join

  title={Performing Group-By before Join},
  author={Weipeng P. Yan and Per-{\AA}ke Larson},
Assume that we have an SQL query containing joins and a group by The standard way of evaluating this type of query is to rst perform all the joins and then the group by operation However it may be possible to perform the group by early that is to push the group by operation past one or more joins Early grouping may reduce the query processing cost by reducing the amount of data participating in joins We formally de ne the problem adhering strictly to the semantics of NULL and dupli cate… CONTINUE READING
Highly Cited
This paper has 129 citations. REVIEW CITATIONS

From This Paper

Topics from this paper.


Publications citing this paper.
Showing 1-10 of 76 extracted citations

130 Citations

Citations per Year
Semantic Scholar estimates that this publication has 130 citations based on the available data.

See our FAQ for additional information.


Publications referenced by this paper.
Showing 1-10 of 10 references

Performing group-by before join

  • Weipeng P. Yan, Per- Ake Larson
  • Technical Report CS 93-46,
  • 1993
5 Excerpts

Translating and op- timizing SQL queries having aggregates

  • G unter von B ultzingsloewen
  • In Pro- ceedings of the 13th International…
  • 1987
1 Excerpt

Similar Papers

Loading similar papers…