Here is 2 different version's of practically the same aggregation.
See images below please.
Version 1.) Smaller aggregation file size.
Version 2.) Process Index is twice as fast.
Both version's queries take the same amount of time because it seems even though I create two versions of the aggregation, SSAS creates the same aggregation data set. Any idea whats going on here, there's plus and minus' to both versions...thanks.
Version1: http://img405.imageshack.us/img405/7673/vers1og4.jpg
Version2: http://img255.imageshack.us/img255/2488/vers2mo0.jpg
Hate to bump, but no one knows whats going on here? We are using version 2...it processes much faster so we can create more aggregations.
No comments:
Post a Comment