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