Re: INDEX CREATE

Hi,

I really don't know what the PL/SQL script is trying to accomplish but I suggest using rowid to make the DELETE operation much faster!

See below.

DECLARE
 CURSOR memory is

     select 
         col1,
         col2,
         col3,
         rowid
     from
         my_table;
 

 --EXECUTABLE SECTION
 BEGIN

     FOR i in memory LOOP
         delete from my_table
             where rowid = i.rowid;
 
	 (....) 
     END LOOP;

Hope this helps.

Maarten Received on Fri Jul 16 1999 - 08:12:29 CEST