Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » optimizer » Distinct aggregation   (RSS)

Distinct Aggregation Considered Harmful

Distinct aggregation (e.g. select count ( distinct key) …) is a SQL language feature that results in some very slow queries. It’s particularly frustrating that you can take a perfectly efficient query with multiple aggregates, and make that query take
 
Page view tracker