One way to address that is by picking an analytical DB that works well with joins without needing to denormalize data. StarRocks claims [1] to do better than Cl

One way to address that is by picking an analytical DB that works well with joins without needing to denormalize data. StarRocks claims [1] to do better than ClickHouse in that regard. [1] https://www.starrocks.io/blog/benchmark-test https://www.starrocks.io/blog/benchmark-test