[PERFORM] slow cursor

[Sriram Dandapani]

Hi   I have a cursor that fetches 150K rows and updates or inserts a table with 150K rows.   It takes several minutes for the process to complete (about 15 minutes). The select by itself (without cursor) gets all rows in 15 seconds.   Is there a way to optimize the cursor to fetch all records and speed up the process. I still need to do the record by record processing