Long compile time with complex view structure

Details

Detail name Value
Changelog Number 4937
Type Bug
Status Resolved
Affected Versions EXASOL 6.0.0
Fix Versions EXASOL 6.0.3
Resolution Date 2017-08-18

Some queries with a complex view structure, i.e views / WITH-clauses deeply nested into other views / WITH-clauses, might take a long time for compilation (more than a few seconds).

While there are other reasons for high compile time, some of those cases are caused by internal functions that are called too often in case of deeply nested views. Those cases will be corrected here. This might even lead to general improvements in compile time of complex queries compared to Version 5.

Note that without developer tools it is impossible to detect those cases on your own. It might be easiest to check your query again after this issue has been resolved.