Section 8.3.1.7, “LEFT JOIN and RIGHT JOIN Optimization” - Oracle ...

Table B is set to depend on table A and all tables on which A depends. Table A is set to depend on all tables (except B ) that are used in the LEFT JOIN condition ...

docs.oracle.com