SQL query performance using JOIN!

5    30 Nov 2015 16:32 by u/s1r2t

1 comment

0

The stunningly original conclusion:

Important learning is to use joins wherever possible instead of cursors. Cursors are recommended only when there is complete business logic which absolutely cannot be accomplished by joins. Also we should ensure that the join based approach returns the exact same result set returned by cursors based approach.