Hacker News new | ask | show | jobs
by jimlikeslimes 877 days ago
My mental model was always that the order of keywords mirrored the order the database engine applied them. So WHERE is processed first and SELECT last.
2 comments
defaultcompany 876 days ago
It’s not really mirrored (assuming you meant reversed). Here’s a page describing the two orders in relation to each other from a wiki I wrote:

https://github.com/weinberg/SQLToy/wiki/Two-Key-Concepts

link
jimlikeslimes 876 days ago
Oh wow, the wiki / project looks fantastically interesting. I've bookmarked it for a deeper read in the future.

Yes I did mean reversed.

link
baq 877 days ago
try EXPLAIN ANALYZE (or just plain EXPLAIN) and see for yourself!
link