1 Reply Latest reply: Jun 2, 2015 8:00 AM by Marcus Sommer RSS

    AGGR using index fields - performance

    Georgina Spary

      In an expression using AGGR, is it more performant to use a join field

      =Sum(AGGR(ONLY([MyCount]), %%QV_RegnID))

       

      or a non join field

      =Sum(AGGR(ONLY([MyCount]), REGNID))


      ?


      I know it's a bad idea to use join fields for display/ reporting but surely it's good to aggregate by an index? or is that not how QV works?