DEV Community

loading...

Discussion on: Tricksy Little Postgres Query Planner

Collapse
mculp profile image
Matt Culpepper

Nice write up! Can you add the original query so I can compare it to the updated one?

Collapse
jgaskins profile image
Jamie Gaskins Author

Ah, right, I completely forgot to add it to the post. It was something like this:

SELECT table1.*
FROM table1
LEFT JOIN table2 ON table1.id = table2.table1_id
WHERE (table1.table3_id = 123456 AND table1.flag)
OR (table2.table3_id = 123456 AND table1.other_flag)