Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    95

    Unanswered: CURSOR or a FOR LOOP

    hello everybody.

    I would like to get some advice for which is best (in performance):
    • a cursor, with the declaration, the open cursor, the fetch, etc.

    or
    • a for loop based on a select


    Thanks in advance.

  2. #2
    Join Date
    Nov 2006
    Posts
    82
    Probably now the performance difference is not big but I think still implicit cursors (for loop ...) are faster.
    Some time ago Burleson wrote something about that, see here
    Implicit vs. Explicit Cursors which is faster - cursor_comparison.sql script

  3. #3
    Join Date
    May 2004
    Posts
    95
    thanks

    it was my first idea, but nothing like more opinions to clear all doubts

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •