You have me curious which databases would not make this optimization, it seems like table stakes?
For example, many NoSQL databases are less sophisticated in query planning.