Optimization of application of index based group by

Details

Detail name Value
Changelog Number 4309
Type Improvement
Status Resolved
Fix Versions Exasol 6.1.1
Resolution Date 2019-01-23

Situation
Under very restrictive preconditions Exasol uses existing indices to reduce TEMP usage of large aggregations and hence, improve performance of such queries.

It has turned out that especially for cases of few group keys or strong root filters, the standard group by was faster than the index based variant.

Improvement
The use of index based group by has been restricted to cases of many index keys, weak root filters and/or the existence of a having clause.