Hi all,
I want to know if the order of dimensions in AGGR function can influence the performance.
Eg. Fields:
X >>> 50.000.000 or rows
Y >>> 10 rows
Z >>> 500 rows
1. Agg(sum(Qty), X,Y,Z)
2. Agg(sum(Qty), Y,Z,X)
What is the best AGGR, 1 or 2?
Regards
Luca Jonathan Panetta
PLJ Software