4 ms·
> Performance hint: developers using cursors should have their hands cut off. This should do the trick. What is wrong with cursor?
by siscia 6y ago
> Performance hint: developers using cursors should have their hands cut off. This should do the trick.
What is wrong with cursor?
- unklefolk 6y agoPerformance basically. As SQL is a set based language you can often replace cursors (which are basically loops) with joins and that is orders of magnitude quicker for larger workloads.
- tehjoker 6y agoSomehow I managed to avoid learning to use cursors and I have never seemed to need them. It seems like this was some kind of grace.