Can you replace an aggr() by an set analysis

[timmy]

Hey

Does anybody has ever tried to replace and aggr() with a set analysis to get some more performance?

tnx

[fernandotoledo]

Hi

You can´t replace one for another because their purpose are diferent.

Set Analysis could be used to replace an IF() statement inside an aggregation like sum(), avg(), count().

In this cases the performance is quite the same, but there are somethings you can do only using the new Set Analysis statement. In most cases the real gain is in Set Analysis´s lower code complexity.

Best Regards,

Fernando