News for hackers. Stuff that matters.
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