Replication of small import subselects and virtual schema tables for joins

Details

Detail name Value
Changelog Number 6872
Type Improvement
Status Resolved
Fix Versions Exasol 6.0.13, Exasol 6.1.1
Resolution Date 2018-11-30

Situation
Virtual schema access can be mapped to an import subselect subquery. Import subselects store data in a temporary table and use this in the original query context.

If the query context is a join queue where the import subselect is joined, small table replication could be applied to avoid expensive global joins. But, the optimizer never replicated import subselects whatever their size was.

Improvement
Small materializations from import subselects are now replicated in joins. The behaviour is consistent with the usage of other temporary tables. The subquery replication border is 100.000 rows by default.