RE: how to optimize insert into t select * from t2

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 12 Mar 2004 15:21:02 +0000
Message-Id: <s051d58b.028@bristol21.bristol.ac>

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_at_csedge.com
> Sent: 12 March 2004 14:52
> To: AWells_at_csedge.com; oracle-l_at_freelists.org
> 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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri Mar 12 2004 - 09:22:47 CST