Re:Better SQL JOINs
by jansommer on Saturday December 25, 2021 @09:25PM
(#29689107)
CTE's are indeed nice, but can also make your queries substantially slower, at least in Postgres
[ Parent
| on HN ]
Re:Better SQL JOINs
by DangitBobby on Sunday December 26, 2021 @03:23AM
(#29690686)
That's mainly true because you don't have the benefit of an index when you join on a CTE, isn't it?