Distinct Aggregation Considered Harmful

Distinct aggregation (e.g. select count(distinct key) ) is a SQL language feature that results in some very slow queries. Its particularly frustrating that you can take a perfectly efficient query with multiple aggregates, and make that query take forever just by adding a distinct keyword to one of the aggregates. For instance, it often makes logical sense to compute distinct counts along the way while you are computing other aggregates.