Improving COUNT DISTINCT Performance with Approximate Functions
Bryan Herger, Vertica Big Data Solution Architect at Micro Focus
November 16, 2022
A common analytic use case is to find the number of distinct items in a data set. Vertica performs well at solving COUNT DISTINCT in a few ways. Since Vertica stores all data in columns, it is possible to optimize for COUNT DISTINCT by building a projection that is tuned for this use case. Vertica...