It's pretty much impossible to decide what an optimised query should look like on a different databases with different data.
Slow network? Fast disks? GPU optimised joins? No way to know what execution order should be, and that's a strength of the relational model.
It's pretty much impossible to decide what an optimised query should look like on a different databases with different data.
Slow network? Fast disks? GPU optimised joins? No way to know what execution order should be, and that's a strength of the relational model.