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?

       

      Regards

      Luca Jonathan Panetta

      PLJ Software