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.
