Re: INDEX CREATE
From: Maarten Scharroo <mscharroo_at_hr.nl>
Date: Fri, 16 Jul 1999 08:12:29 +0200
Message-ID: <378ECD4D.7467_at_hr.nl>
Date: Fri, 16 Jul 1999 08:12:29 +0200
Message-ID: <378ECD4D.7467_at_hr.nl>
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