append wont help with all those indexes. > > From: "Carel-Jan Engel" <cjpengel.dbalert@xxxxxxxxx> > Date: 2004/03/12 Fri AM 10:50:54 EST > To: oracle-l@xxxxxxxxxxxxx > Subject: RE: how to optimize insert into t select * from t2 > > > /*+ 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. > > e.g. a Data Guard setup, which especially benefits from FORCE LOGGING....... > > > Regards, Carel-Jan > > === > If you think education is expensive, try ignorance. (Derek Bok) > === > > ---------------------------------------------------------------- > 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 > ----------------------------------------------------------------- > ---------------------------------------------------------------- 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 -----------------------------------------------------------------