Clickhouse also does joins.
Somehow StarRocks dudes appear in every relevant post with this false claim.
Somehow StarRocks dudes appear in every relevant post with this false claim.
My experience with Clickhouse is that its joins are not performant enough to be useful. So the best practice in most cases is to denormalize. I should have been more specific in my earlier comment.
its common best practice on any database, because if both joined tables don't fit memory, then merge join is O(nlogn) operation which indeed many times slower than querying denormalized schema, which will have linear execution time.