Which aggregate function is good at performance

hyudolee
hyudolee
in Modeling

Hi, I want to use aggregate function.

I want to aggregate "Date" Lineitem from Order A&B to Aggregation Module.

Date Lineitem has Date format.

 

I use " OrderA.Date[Max:Product]" as Formula.

And I can also use "Fristnonblank" and so on because Date Lineitem is common in module.

 

Which Formula is good at performance?

 

hyudolee_3-1639731804513.png

hyudolee_4-1639731816594.png

 

hyudolee_2-1639731382660.png

 

Each Order has Product, But Product will not duplicate.

And Order A and Order B has own date. It depends on Own module.

Tagged:

Best Answer

  • Misbah
    Misbah
    Answer ✓

    @hyudolee 

     

    I don't think there is any work that has been done on the comparison of the performance of these aggregation functions. I have a feeling that these two will perform almost similarly.

     

    Misbah

    Miz Logix

Categories