Improved profiling information for query part ANALYTIC FUNCTION
Details
| Detail name | Value |
|---|---|
| Changelog Number | 6764 |
| Type | Improvement |
| Status | Resolved |
| Fix Versions | Exasol 7.0.0 |
| Resolution Date | 2020-09-11 |
The query profiling of profile part ANALYTIC FUNCTION has been improved:
- GLOBAL part info is more consistent
- separate profile trace for each distinct partition by and/or order by clause (implying another expensive AF computation round)
- REMARKS column shows information about the counts of partition and order keys as well as the number of analytical functions
- #Partitionkey means the number of partition key expressions in this analytic function computation
- #Orderings means the number of different order key combinations in this analytic function computation (with the same partition keys)
- #Functions means the number of different analytic expressions in this analytic function computation