Performance Analysis of the Data Aggregation in the Oracle Database

The amount of data for processing and evaluation is growing enormously. Temporal database monitoring object state evolution is an inseparable part of the analytics. Oracle Database provides a robust environment for treating complex datasets by offering indexing, partitioning, and other enhancements allowing to create scalable systems. Aggregate and analytic functions in SQL are associated with the data groups or partitions, characterizing the data set over which individual functions are evaluated. Commonly, groups are not defined only by the attributes, instead, function results and transformations form the groups. This paper deals with the performance of the group definition associated with the function calls, referenced by the pure definition or aliases, introduced in Oracle 23c.