COUNT (DISTINCT) and Other DISTINCT Aggregates
Computing a DISTINCT
aggregate generally requires more work than other aggregates. Also, a query that uses a single DISTINCT
aggregate consumes fewer resources than a query with multiple DISTINCT
aggregates.
Tip: Vertica executes queries with multiple distinct aggregates more efficiently when all distinct aggregate columns have a similar number of distinct values.