H. Features Introduced in Ingres 2.6 : Internal Performance Enhancements : Aggregate Sort Nodes
 
Share this page                  
Aggregate Sort Nodes
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.