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

Status : 

 


6
0
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

Description

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.