Zonemaps used for local join speedup
Details
| Detail name | Value |
|---|---|
| Changelog Number | 17362 |
| Type | Improvement |
| Status | Resolved |
| Fix Versions | Exasol 8.24.0 |
| Resolution Date | 2023-12-20 |
Background
Version 8 introduced the concept of zonemaps which allows the database to decrease I/O and computation cost of some queries. In some cases, they could also be used to speed up data filtering.
Improvement
The number of cases in which zonemaps can be used to speed up data filtering is expanded, for example in a local join. More queries are now able to take advantage of the performance improvements due to zonemaps
