Home Forums Article Discussions Article Discussions by Author Discuss content posted by Dave Ballantyne Optimizing a cursor based routine – Part 1 RE: Optimizing a cursor based routine – Part 1
wbrianwhite
SSC Eights!
Points: 954
More actions
June 28, 2011 at 2:32 pm
#1345500
I'm not sure why you're keeping this in a cursor at all. The report looks simple enough to just write the entire report as a big select statement. Which will be an order of magnitude faster than a cursor.