GROUP_CONCAT performance improvement
Details
| Detail name | Value |
|---|---|
| Changelog Number | 30391 |
| Type | Improvement |
| Status | Resolved |
| Fix Versions | Exasol 2026.1.0, Exasol 2025.1.11 |
| Resolution Date | 2026-05-15 |
Background
GROUP_CONCAT is a common string-aggregation primitive in many use cases. The prior implementation of this function did not meet our performance expectations when scaling to many-core nodes.
Improvement
A performance optimization has been performed on GROUP_CONCAT. This has the potential for substantial improvement in the query execution time for queries which involve this function, particularly on a machine with many cores, a Non-Uniform-Memory-Access (NUMA) architecture, or both.
