-
Products and Technology
By Category
-
Groups
Activity Groups
Industry Groups
Influence and Feedback Groups
Interest Groups
Location Groups
Customer Only Groups
- Developers
- Partners
- Events
- Help Center
- Topic Pages
-
Explore SAP
Products
- Autonomous Enterprise
- Artificial intelligence
- Data and analytics
- Autonomous Suite
- Technology platform
- Transformation management
- Midsize business solutions
- Financial management
- Spend management
- Supply chain management
- Human capital management
- Customer experience
- Enterprise resource planning
- Business network
- Sustainability management
- SAP Store
- Try SAP
- View all industries
- Partners
- Services
Learning and Support
-
- Products and Technology
- Groups
- Developers
- Partners
- Events
- Help Center
- Topic Pages
-
Explore SAP
- Explore SAP
-
Products
- Products
- Autonomous Enterprise
- Artificial intelligence
- Data and analytics
- Autonomous Suite
- Technology platform
- Transformation management
- Midsize business solutions
- Financial management
- Spend management
- Supply chain management
- Human capital management
- Customer experience
- Enterprise resource planning
- Business network
- Sustainability management
- SAP Store
- Try SAP
- View all industries
- Partners
- Services
- Learning and Support
- About
- SAP Community
- Groups
- Interest Groups
- Application Development and Automation
- Discussions
- Re: Aggregate Functions
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Aggregate Functions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2021 May 10 9:49 AM
- SAP Managed Tags
- ABAP Development
- ABAP Testing and Analysis
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2021 May 10 9:58 AM
- SAP Managed Tags
- ABAP Development
- ABAP Testing and Analysis
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2021 May 10 9:58 AM
- SAP Managed Tags
- ABAP Development
- ABAP Testing and Analysis
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2021 May 10 10:19 AM
- SAP Managed Tags
- ABAP Development
- ABAP Testing and Analysis
Have you tried reading the online ABAP keyword documentation?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2021 May 10 10:45 AM
- SAP Managed Tags
- ABAP Development
- ABAP Testing and Analysis
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/#
Bluesky