Improved compile time of queries for users with many roles
Details
| Detail name | Value |
|---|---|
| Changelog Number | 11493 |
| Type | Improvement |
| Status | Resolved |
| Fix Versions | Exasol 8.10.0 |
| Resolution Date | 2023-02-17 |
Background
For the first statement of every transaction, additional overhead is required e.g. for loading metadata objects into the new transaction scope of the session.
This overhead can be identified by higher compile times.
Description
The compile-time of these queries depends on the number of roles the current user has.
Improvement
Improved compile-time for the first query of every transaction by reducing the impact of the number of roles the current user has.
