OPEN .. FETCH CURSOR
K KiranOct 8 2007 — edited Oct 8 2007Hi,
I would like to know the execution of query when using OPEN CURSOR and FETCH CURSOR. I know that OPEN CURSOR will hold the data in the cursor and when FETCH is executed, single records are fetched each time. But can someone tell me if single record FETCHed is by executing the SQL query each time ? or just getting data from the cursor area.
I have this question because ...I have two cursors .. 1st cursor takes all the data from a single table that has huge number of records and when fetch is executed it doesnt take much time. On the otherhand ..2nd cursor is with multiple tables and less data but when fetch is executed .. it takes almost double the time as 1st cursor , with not even half the number of records.