Correlated queries can cause excessive compile times
Details
| Detail name | Value |
|---|---|
| Changelog Number | 12634 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 7.0.0, Exasol 7.1.0 |
| Fix Versions | Exasol 7.0.12, Exasol 7.1.1 |
| Resolution Date | 2021-08-31 |
Description
A correlated subquery in combination with a complex view hierarchy can cause excessive compile times.
Workaround
Rewrite the query without a correlation.
Fix
Query compiles with normal duration
