Re: performance comparision
From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sat, 30 Jan 2010 11:20:27 +0100
Message-ID: <73a38$4b6407eb$524ba3af$16783_at_cache2.tilbu1.nb.home.nl>
UXDBA wrote:
> LOOP
> DELETE FROM T1
> WHERE dev = 1 AND ROWNUM <= batch_size;
>
> cnt := cnt + SQL%ROWCOUNT;
> COMMIT;
> DBMS_OUTPUT.put_line ( 'Deleted ['
> || cnt
> || '] rows from T1'
> );
> END LOOP;
>
I rest my case: Loop commit; end loop;
Date: Sat, 30 Jan 2010 11:20:27 +0100
Message-ID: <73a38$4b6407eb$524ba3af$16783_at_cache2.tilbu1.nb.home.nl>
UXDBA wrote:
> LOOP
> DELETE FROM T1
> WHERE dev = 1 AND ROWNUM <= batch_size;
>
> cnt := cnt + SQL%ROWCOUNT;
> COMMIT;
> DBMS_OUTPUT.put_line ( 'Deleted ['
> || cnt
> || '] rows from T1'
> );
> END LOOP;
>
I rest my case: Loop commit; end loop;
Please read the concepts guide. Then, read some pf tom kyte's books. Start with the concepts guide, chapter three, and read it again.
Then start complaining about how stupid this approach is.
-- Regards, Frank van Bortel Topposting in Usenet groups I regard as offensive - I will not replyReceived on Sat Jan 30 2010 - 04:20:27 CST