Unnecessary index rebuilds in UNION ALL

Details

Detail name Value
Changelog Number 21052
Type Bug
Status Resolved
Affected Versions Exasol 7.1.0, Exasol 8.0.0
Fix Versions Exasol 2025.1.0, Exasol 8.29.11
Resolution Date 2025-07-08

Description

Under specific circumstances (hashing mismatch) it is possible for UNION ALL statements to rebuild global indices even when matching indices exist. This result in unnecessary index rebuilds and potentially prolonged execution of statements triggering such a rebuild.

Workaround

There are no straightforward workarounds.

Fix

There are no unnecessary index rebuilds.