RE: a quick SQL performance question - rethinked

Hi Andrey, If the volume of rows is not too great, you can use a technique I've used. Retrieve the rowids and store them in a PL/SQL table as you process them. At the end of the processing loop, use a forall loop to delete the rows using the PL/SQL table. I know a 2000 row PL/SQL table shoul

Re: a quick SQL performance question - rethinked

Andrey, Instead of explicitly using 'where rowid = ', why not consider the use 'for update of' and 'where current of'? Raj Andrey Bronfin