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.