Misleading durations of joins in query profiling
Details
| Detail name | Value |
|---|---|
| Changelog Number | 14065 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 7.0.5 |
| Fix Versions | Exasol 8.0.0, Exasol 7.1.7 |
| Resolution Date | 2022-03-16 |
Background
A query profile provides a model of a query's cost distribution between profile parts like joins or aggregations. This profile can help you to optimize or rewrite the query.
Description
The profile of a query with multiple joins may incorrectly distribute durations between the joins.
E.g. one join shows higher costs at the expense of another join.
The overall duration is unaffected.
Workaround
There is no workaround.
Fix
The duration values of join profile parts reflect their true costs more accurately.
