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

  • 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.