Performance Improvement

[Former Member]

If you use cursor will it improve the performance of a program?

if you use cursors in DB2 database and if you go for other data base(replatform to oracle) for example oracle will we have any problem with cursors? is cursors belong to open sql or native sql?

[Former Member]

I've never known it to improve performance. It's used to allow several independent access paths to the same table.

It's an open SQL commnad.

You can see more by pressing F1 on OPEN.

Rob

[Former Member]

Open cursor processing is necessary for blockwise processing of very large amounts of data, (blocks of about 10.000 records, at least several blocks) Then it helps, becomes otherwise it is hard to find to next block.

For standard SQL problems it is not necessary.

Siegfried

[Former Member]

I think the PACKAGE SIZE option of the SELECT statement is a better option for large amounts of data. So a cursor is not needed in that case.

Rob