topic Re: Aggregate Functions in Application Development and Automation Discussions

Aggregate Functions

ishwarya_doss — Mon, 10 May 2021 08:49:55 GMT

Hi Experts,

I'm looking for details about how aggregate functions work in SQL select statements in Oracle DB version & ABAP 740 release SP 15 .

Will the usage of aggregate functions improve or worsen the performance? If so, when should it not be used? Kindly share if any documents are found related to this queries.

Re: Aggregate Functions

hohoman — Mon, 10 May 2021 08:58:17 GMT

Hello,

I am not an Database expert but from an abap developers view I had made the experience that on normal and high performance databases it was always better to let the DB make the aggregation instead of doing it on the ABAP application server.

Regards

Holger

Re: Aggregate Functions

matt — Mon, 10 May 2021 09:19:51 GMT

Have you tried reading the online ABAP keyword documentation?

Re: Aggregate Functions

ishwarya_doss — Mon, 10 May 2021 09:45:20 GMT

Yes, I have read the keyword documentation. But when I searched for the performance-related details, I got confused after seeing few blogs like this. Hence wanted to confirm. Also I'm not familiar on the DB part.

https://blogs.sap.com/2014/09/17/use-of-aggregate-function-in-abap/#