Sign in
Tips, Tricks, and Advice from the SQL Server Query Processing Team
The query processing team - query optimization & execution - providing tips, tricks, advice and answers to freqeuently-asked questions in a continued effort to make your queries run faster and smoother in SQL Server.
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Tags
Compilation time
data warehousing
Distinct aggregation
Estimate Rows
ETW
Hash Join
Indexing
Memory Management
OLAP
OLTP
optimizer
Query cost
query memory
query optimization
Query plan
Showplan
Showplan_XML
SQL Profiler
SQL Server 2005
SQL Trace
Star Join
Statistics Profile
Statistics XML
Tracing
Browse by Tags
MSDN Blogs
>
Tips, Tricks, and Advice from the SQL Server Query Processing Team
>
All Tags
>
query optimization
Tagged Content List
Blog Post:
Distinct Aggregation Considered Harmful
SQL Server Query Processor Team
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 forever just by adding a distinct keyword to one...
on
22 Sep 2008
Page 1 of 1 (1 items)