Improved performance of EXA_SCHEMAS
Details
| Detail name | Value |
|---|---|
| Changelog Number | 14772 |
| Type | Improvement |
| Status | Resolved |
| Fix Versions | Exasol 7.1.11, Exasol 8.0.6 |
| Resolution Date | 2022-06-09 |
Background
The system table EXA_SCHEMAS lists all schemas that the current user has access to.
EXASOL-2659 introduced the concept of USAGE.
The intention of USAGE is to hide all schemas from a user that he has no USAGE privilege on (or system privilege USE ANY SCHEMA).
Improvement
Improved query performance for EXA_SCHEMAS when USE ANY SCHEMA is not granted to PUBLIC, especially when a user has many roles and there are many schemas.
