Answers are grounded in this paper and cite their sources.
Most aggregation queries contain both group-by and join operators, and spend a significant amount of time evaluating these two expensive operators. Merging them into one operator (the groupjoin ) significantly speeds up query execution. We introduce two main equivalences to allow for the merging and prove their correctness. Furthermore, we show experimentally that these equivalences can significantly speed up TPC-H.
No takes yet. Share an insight, caveat, or question.
Moerkotte et al. (2011) studied this question.
Synapse has enriched 10 related papers. Consider them for comparative context: