Starflake reflections based on outer joins fails to take effect

Dremio’s optimizer will soon be able to perform inner joins on starflake reflections that are based on outer joins. A reflection with an outer join can be utilized by the optimizer to accelerate a query with an inner join by applying a filter on top of the outer join to drop records in which the join key on one side is null.

– As I tested, this scenario failed to appear.i.e., we are not able to leverage the starflake reflection based on left outer join to accelarate a query with an inner join as the doc narrates.
so what’s the matter?

1 Like