Skip to content

Aggregation Semantics and Optimization in SQL: GROUP BY Clause Extension in Oracle Database 26ai

Oct 2026 · 2026 New Trends in Signal Processing (NTSP) · pp. 1-6 · 0 citations · 11 references

Abstract

Oracle Database is a leading enterprise relational database management system, supporting both transactional and analytical workloads. Recent SQL enhancements, including the introduction of the GROUP BY ALL construct, improve query expressiveness, maintainability, and developer productivity by implicitly including all non-aggregated SELECT expressions in grouping operations. This study investigates the semantics, formal properties, and performance implications of aggregation in Oracle SQL, with a focus on GROUP BY ALL. We evaluate its impact on execution plans, optimizer cost, and query performance using a high-resolution flight monitoring dataset. Experimental results demonstrate that GROUP BY ALL preserves execution efficiency while simplifying query formulation, with negligible overhead compared to explicit attribute enumeration. Building on these findings, we propose a future transformation layer that will preprocess user queries into optimized representations for the query engine, enabling portability across database systems and versions. This approach will address limitations of the ALL keyword, enhance flexibility in query construction, and lay the groundwork for further innovations in automated query optimization.

View source

We use cookies to run the site and, with your consent, for analytics and to show ads. See our Cookie Policy.