Introduction of COLUMN STATISTICS in profiling tables
Details
| Detail name | Value |
|---|---|
| Changelog Number | 5109 |
| Type | Improvement |
| Status | Resolved |
| Fix Versions | Exasol 7.1.0 |
| Resolution Date | 2021-08-03 |
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.
