Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
Thanks in advance for your help.
What is more efficient between SUM(FieldA)*Constant and SUM(FieldA*Constant)?
I would believe that SUM(FieldA)*Constant should be better because the other option will perform the multiplication on each row and then sum it.... whereas in this case, it sums and only perform multiplication once.
I would believe that SUM(FieldA)*Constant should be better because the other option will perform the multiplication on each row and then sum it.... whereas in this case, it sums and only perform multiplication once.