Brahmanand Shukla - Thursday, September 27, 2018 9:01 AM
And yes, I also disagree with #21 Don’t use CURSOR. Use WHILE loop in place of cursor.
Yes, avoid cursors where possible. But where appropriate a fire hose cursor can perform better than WHILE loop with temporary tables that require maintenance to support the loop. Plus, even a cursor requires a WHILE loop.