While counting is common in every application, sometimes it is not enough: when we need to display the amount of unique users generating traffic in our website or provide the number of disparate items included in an order we need to apply a distinct count. Compared to a classical count, the distinct one is usually… Continue reading How to speed up COUNT(DISTINCT)