High compile time for complex views in START WITH expression
Details
| Detail name | Value |
|---|---|
| Changelog Number | 13292 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 7.1.0 |
| Fix Versions | Exasol 7.1.3 |
| Resolution Date | 2021-11-26 |
Description
The compile-time of a query can be high if the following conditions are met
- the query contains a CONNECT BY expression
- the CONNECT BY expression contains START WITH
- START WITH references complex views
Workaround
Materialize the view as a table.
Fix
In such circumstances the compile time is reduced.
