And then comes Oracle and insists on applying equality filters first, because, duh, they are fast, and never take any of those other details into consideration.

Honestly, Postgres does it right - you can enforce your query plan to any level of detail you want.