A Hidden Benefit of Implicit Joins: Join Elimination

FROM actor LEFT JOIN film_actor ON actor.actor_id = film_actor.actor_id LEFT JOIN film ON film_actor.film_id = film.film_id LEFT JOIN film_category ON film.film_id = film_category.film_id LEFT JOIN category ON film_category.category_id = category.category_id FROM actor LEFT JOIN film_actor ON actor.actor_id = film_actor.actor_id LEFT JOIN film_category ON film_actor.film_id = film_category.film_id LEFT JOIN category ON film_category.category_id = category.category_id This is a great optimisation in particular because with implicit path joins, jOOQ users can’t really hand-write these optimisations as they’re not authoring the join tree in the FROM clause themselves.