Join elimination is a query transformation of the Oracle optimizer to remove joins that are not required in a query. A very practical features for star schema queries as well as ETL processes in data warehouses, but it is important to know what preconditions must be satisfied. And good to know: The behavior is different in Oracle 12c than in previous database versions.
Join Elimination: Difference in Oracle 11g and 12c
1