Currently, aggregating messages involves two identical joins and selects, which are then unioned. It might be worth analyzing if performance improves by first unioning msgToSrc and msgToDst, and then performing a single join and select.