Uploaded image for project: 'EXASOL Roadmap'
  1. EXASOL Roadmap
  2. EXASOL-2932

Introduction of COLUMN STATISTICS in profiling tables

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Fix Version/s: Exasol 7.1.0
    • Component/s: None
    • Labels:
      None

      Description

      Background

      The time spent in computing column statistics was previously included in the COMPILE / EXECUTE part of a pipeline in the public profiling tables.

      Improvement

      The profiling tables

      • EXA_DBA_PROFILE_LAST_DAY
      • EXA_USER_PROFILE_LAST_DAY
      • EXA_DBA_PROFILE_RUNNING
      • EXA_USER_PROFILE_RUNNING

      now show an additional profiling part COLUMN STATISTICS, which indicates that the database is computing statistics on a column for internal optimization. When consecutive, these parts are combined by the table with the remarks field having a comma-separated list of the columns over which statistics were computed.

        Attachments

          Activity

            People

            • Assignee:
              CaptainEXA Captain EXASOL
              Reporter:
              CaptainEXA Captain EXASOL
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: