conditional-aggregation

Short summary Performance of subqueries method depends on the data distribution. Performance of conditional aggregation does not depend on the data distribution. Subqueries method can be faster or slower than conditional aggregation, it depends on the data distribution. Naturally, if the table has a suitable index, then subqueries are likely to benefit from it, because … Read more