Compile Time Increase in Queries With Analytic Functions and Nested Views
Details
| Detail name | Value |
|---|---|
| Changelog Number | 9411 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 6.2.0 |
| Fix Versions | Exasol 7.0.0, Exasol 6.2.5 |
| Resolution Date | 2020-01-29 |
Problem
In queries that combine many analytic functions with deeply nested views, the compile time in Exasol 6.2.x is considerable higher than in Exasol 6.1.x.
It is possible to identify this issue by comparing the profiling between 6.1.x and 6.2.x.
The profiling of an affected query shows a huge increase in the Compile/Execute between the two versions. Additionally, the profiling shows the use of analytic functions in both versions.
There is no workaround.
