Performance Degradation with the Aggregate Function and Unrelated Dimensions - by Teo Lachev

Status : 


Sign in
to vote
ID 778563 Comments
Status Active Workarounds
Type Bug Repros 1
Opened 2/5/2013 5:33:34 AM
Access Restriction Public


When Aggregate function is used with a unrelated (hanging) dimension (a dimension that doesn't join any measure group), the query has a very poor performance. Replacing Aggregate with Sum fixes the performance issue.
Sign in to post a comment.