Re: Re: Which method is more efficient

so GTT's help reducing redo when you do inserts and deletes? but not for deletes? there was a post by tom kyte on dejanews from a few years back where someone asked the redo question and he recommended GTTs.

here is the link... did I misread it?

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=89r5a7%249q3%241%40nnrp1.deja.com&rnum=1&prev=/groups%3Fq%3Doracle%2Bglobal%2Btemp%2B%2Bkyte%2Bredo%26ie%3DUTF-8%26oe%3DUTF-8%26hl%3Den%26btnG%3DGoogle%2BSearch
>
> From: Richard Foote <richard.foote_at_bigpond.com>
> Date: 2003/05/29 Thu AM 08:45:46 EDT
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: Re: Which method is more efficient
>
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Thursday, May 29, 2003 3:14 AM
>
>
> > 1. to totally eliminate redo, load your staging records into a global temp
> table. it has absolutely no redo and is very fast.
>
> Hi
>
> The above is not quite true. Global temp tables *do* generate redo (albeit
> indirectly) and potentially quite a bit of it. The point to make here is
> that changes to GTT generate undo and this undo makes changes to undo
> segments and these changes subsequently generate redo. So depending on the
> type of DML (eg. deletes) and the volume of changes, you can end up
> generating quite a bit of the redo.
>
> Not as much as a non-GTT but enough to certainly invalidate the above
> statement.
>
> Cheers
>
> Richard Foote
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Richard Foote
> INET: richard.foote_at_bigpond.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <rgaffuri_at_cox.net
  INET: rgaffuri_at_cox.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).