Native cloud deployment on Azure is not available for this version of Exasol, but you can install Exasol as a Linux application on Azure instances. For more information, see Installation.

Native cloud deployment on Google Cloud is not available for this version of Exasol, but you can install Exasol as a Linux application on Google Cloud instances. For more information, see Installation.

Improved runtime of EXA_*_PROFILE_LAST_DAY views

Details

Detail name	Value
Changelog Number	12513
Type	Improvement
Status	Resolved
Fix Versions	Exasol 7.1.0
Resolution Date	2021-08-03

Background

Profiling is typically used to analyze and optimize single queries. When an optimization affects not just a single query but the database as a whole (e.g. replication border) or a complete table (e.g. distribution keys), it is often necessary to aggregate profiling information of all queries.
On systems with large amounts of profiling data such aggregation queries can take very long.

Improvement

Query performance for aggregating large profile data has been improved.

Upgrade note

During the update to 7.1 all EXA_*_PROFILE_LAST_DAY data is truncated.

Changed behavior

On first database startup all last day profile data will be truncated.