Maybe useless to you 🙂 but the optimizer is chosing to do something different because of it.

What about the outer join ? Is that what is intended ?