0 Replies Latest reply: Sep 28, 2012 11:43 AM by Luca Jonathan Panetta RSS

    Aggr Performance

    Luca Jonathan Panetta

      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?



      Luca Jonathan Panetta

      PLJ Software