Improvements to aggregate handling allows Ingres to better support data-mining products such as CleverPath OLAP, which make extensive use of data aggregation.

Previous versions required a sort before doing grouping and aggregation. Ingres 2.6 now does grouping with hash bucketing instead of sorting. Hash grouping is usually faster than sorting. Other internal refinements streamline the calculation of common aggregates, reducing the amount of CPU time needed.