3 ms·
The vast majority of recursion in SQL is probably the result of a bad schema.
by pc86 5y ago
The vast majority of recursion in SQL is probably the result of a bad schema.
- bob1029 5y agoI agree with this. If you are doing recursion in SQL, its probably because you have a bad schema. If the schema is clean, then you should probably be doing the recursion in your application logic. There are still cases where it makes sense but its super rare in my experience.
- hobs 5y agoStoring trees for instance, but you can always rewrite your recursive CTE to use a while loop and a stack.
- deleted 5y ago[deleted]