3 ms·
I don't find CTEs particularly fun, copying and pasting the whole tower of CTEs into another SQL window to debug the one I'm interested in is decidedly not a fo
by forgetfulness 3y ago
I don't find CTEs particularly fun, copying and pasting the whole tower of CTEs into another SQL window to debug the one I'm interested in is decidedly not a form of entertainment I pursue.
- barrkel 3y agoYou only need one recursive CTE typically and you can encode it into a view that you join against. It just sucks for performance when you have millions of nodes.