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