Pick records from REF CURSOR in chunks!!
809936Jan 10 2011 — edited Jan 11 2011Hi,
I have a scenario in which I have to pick records from a cursor and write them in a file.
Method 1 : For this I have use a ref cursor and write records in a PLSQL table in chunks (by using limit size) and write them in a file and repeat this process for all chunks.
Method 2: Fetch all records from cursor in one time and use a Database table to write the records and do some updates on records in a database table then write all records in a file in one go.
So My question is which process is more optimized and give better results when we talk for performance tuning.
Please help...
Many Thanks,
Pooja