Accelerating queries with group-by and join by groupjoin
Guido Moerkotte, Thomas Neumann · Proceedings of the VLDB Endowment · 2011
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.