News for hackers. Stuff that matters.
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
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?
Re:Better SQL JOINs by jansommer on Sunday December 26, 2021 @03:06PM (#29695821)
It'a slow even without indexes. In other cases, where the CTE is used multiple times in the same query, it can be faster