4 ms·
CTE's are indeed nice, but can also make your queries substantially slower, at least in Postgres
by jansommer 5y ago
CTE's are indeed nice, but can also make your queries substantially slower, at least in Postgres
- DangitBobby 5y agoThat's mainly true because you don't have the benefit of an index when you join on a CTE, isn't it?
- jansommer 5y agoIt'a slow even without indexes. In other cases, where the CTE is used multiple times in the same query, it can be faster