posted 16 years ago
Thanks Jeanne for your replies .
So when you say there will be two trips to the database :
1 >Where is the resultset stored - is that stored in SGA ( In case of Oracle )
2 >If we are using a resultset - then believe all the data is anyway on the server side ( not like disconnected rowset )
So are you saying that after query execution ( results obtained = 20 rows & fetchSize = 10 ) that 20 rows will be stored in SGA
So where are the first 10 records read / picked from
What happens when we access the 11th record ?
Too many questions and too much confusion at my end .
Any answers will be greatly appreciated .
Regards,
-anagha