Hi April It depends :( /*+ APPEND */ indicates a nologging operation, but then there is the FORCE LOGGING option..... It wouldn't be entirely surprising to find a production dba setting the latter (pace Wolfgang's comment about backup,backup,backup) where the test environment doesn't have it. Cheers Niall P.S. Juan where on earth did you get PCTFREE=3 seems an interesting value. > -----Original Message----- > From: AWells@xxxxxxxxxx > Sent: 12 March 2004 14:52 > To: AWells@xxxxxxxxxx; oracle-l@xxxxxxxxxxxxx > Subject: RE: how to optimize insert into t select * from t2 > > > > Juan... why don't you check on a test system to see if > > insert into select from where > > will for sure not create redo logs. ********************************************************************** This email contains information intended for the addressee only. It may be confidential and may be the subject of legal and/or professional privilege. Any dissemination, distribution, copyright or use of this communication without prior permission of the sender is strictly prohibited. ********************************************************************** ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------