Aggr Performance

[pljsoftware]

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