> I have set index_scan off for tomorrow morning's run. I will let you know > what happens. I think my problem is fixed. By disabling index scan while creating the cursors and then turning it back on again for the small query that occurs in my inner loop the performance has returned to normal (It may infact be better then before). Thanks a bunch. Bryan
