Skip to Content
0
Former Member
Oct 16, 2009 at 11:59 AM

OPEN CURSOR method to fetch data

18 Views

Hi,

Is the following OPEN CURSOR method to fetch data faster than the normal SELECT statement ?

OPEN CURSOR [WITH HOLD] <c> FOR SELECT <result>

FROM <source>

[WHERE <condition>]

[GROUP BY <fields>]

[HAVING <cond>]

[ORDER BY <fields>].

I have read about this in the following URL, it is not mentioned about its adavantages over normal SELECT.

[http://help.sap.com/saphelp_nw04/helpdata/EN/fc/eb3b23358411d1829f0000e829fbfe/content.htm]

Can anyone please let me know if OPEN CURSOR method is faster than normal SELECT and would improve the performance ?

Thanks in Advance.

Edited by: Dagny on Oct 16, 2009 1:59 PM

Edited by: Dagny on Oct 16, 2009 1:59 PM