Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004

    Question Unanswered: db2 cursor perfomance

    I am interested in finding out which is the performance difference between using simple cursor and scrolling cursor on db2 database, os390.
    Last edited by ionutz; 02-02-04 at 15:24.

  2. #2
    Join Date
    May 2003
    That depends on a number of factors, such as whether the cursor is updatable, has an order by, etc.

    It also depends on what additional logic would have to be implemented if a scrollable cursor was not used, but certain logic was required. But in general, a simple cursor is usually the same or more efficient if you don't need any of the features provided by a scrollable cursor.

    You can check out the "Application Programming and SQL Guide" which can be downloaded in PDF format.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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