6 ms·

but SQL execution even in a dumb planner is FROM then WHERE then .... and then finally SELECT and ORDER so I don't get it

• gonzalohm 1y ago
  But a smart query planner would move the where condition into the JOIN condition
  • Sesse__ 1y ago
    Depending on the join type, moving it up into the join (instead of keeping it on the table) would be either irrelevant or actively harmful.