Improved performance of user, role and privileges system tables
Details
| Detail name | Value |
|---|---|
| Changelog Number | 10428 |
| Type | Improvement |
| Status | Resolved |
| Fix Versions | Exasol 7.1.0 |
| Resolution Date | 2021-08-03 |
Improvement
Query performance has been improved for the following system tables:
- EXA_*_USERS
- EXA_*_ROLES
- EXA_*_ROLE_PRIVS
- EXA_*_OBJ_PRIVS
Speedup scales well with
- the size of these tables
- the number of nodes.
The larger the number of concerned database objects and nodes, the more significant the speedup is.