Bloom filters and decorrelated lateral views (DCL)

Database: 19.18 (on Exadata)

We have the following query:

SELECT
FROM

     TABLE_A
           INNER JOIN TABLE_B (join predicates 1 + non-correlated IN subquery returning 1 row)
           LEFT OUTER JOIN TABLE_B (join predicates 2 + non-correlated IN subquery returning 1 row)
           LEFT OUTER JOIN TABLE_C (join predicates 3)
           LEFT OUTER JOIN TABLE_C (join predicates 4)
           LEFT OUTER JOIN TABLE_C (join predicates 5)

Execution plan starts with TABLE_A (cardinality between 1 and 500 rows; it has a date filter and partition pruning occurs). In absence of a good join condition between A and Bs, I tried to force Bloom Filters on Bs using a px_join_filter hint. It works for the first B and the BF created on A is applied to B. However, for the second join with B (the LEFT OUTER JOIN) optimizer chose to transform it into a decorrelated lateral view (VW_DCL_%) and the Bloom filter is not pushed into it (a NO_ACCESS hint can be seen in the outline section). If NO_DECORRELATE hint is added, then I end up with a MERGE with the lateral view VW_LAT_% (which is also not using a BF) but that view is accessed of too many times.