Add caching to improve optimizer performance (Part 1)
Details
| Detail name | Value |
|---|---|
| Changelog Number | 20426 |
| Type | Improvement |
| Status | Resolved |
| Fix Versions | Exasol 8.32.0 |
| Resolution Date | 2024-11-08 |
Background
The optimizer can be slow for queries with complicated SQL, particularly because the optimizations scan the entire abstract syntax tree each time they run.
Improvement
Add caching to optimizations so they know which regions of the abstract syntax tree have changed since the last time the optimization ran and only those regions need to be scanned.
This brings a compile time improvement of up to 25% for every query.
