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.

Slow metadata queries

Details

Detail name	Value
Changelog Number	9605
Type	Bug
Status	Resolved
Affected Versions	Exasol 6.2.0
Fix Versions	Exasol 6.2.5
Resolution Date	2020-03-20

Background

Starting with Exasol 6.2.0, inaccessible schemas are hidden from users as described in EXASOL-2662.

Problem

This new feature may cause performance issues and considerably slow down metadata queries. The actual impact of the problem depends on the number of schemas, number of database objects, number of roles and the configured user privileges.

Workaround for Exasol 6.2.0 - 6.2.4

The command-line parameter -extendedSchemaVisibility=1 will deactivate the feature and restore performance of affected metadata queries.

If the parameter is set, all schemas will be visible for all users - as it was before 6.2.0; visibility of objects within the schemas is not affected.

Changes in Exasol 6.2.5 and above

The hide schema feature is deactivated by default.
It is necessary to set the command-line parameter -extendedSchemaVisibility=0 to reactivate the feature.

Changed behavior

The hide schema visibility feature is turned off. If you want to reactivate the feature, set the commandline parameter -extendedSchemaVisibility=0.