1. alter table ZZ nologging;

2. insert /*+ append */ into ZZ
Select a.*, b.*
From XX a, YY b
Where a.xx=b.xx;

3. commit;

4. alter table ZZ logging;





Please take a few minutes to provide feedback on the quality of service you received from our staff. The Department of Education values your feedback as a customer. Commissioner of Education Jeanine Blomberg is committed to continuously assessing and improving the level and quality of services provided to you.Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: Philip Otunla
[mailto:oracledba-ezmlmshield-x15503725.[Email address protected]
Sent: Monday, July 30, 2007 11:29 AM
To: LazyDBA Discussion
Subject: How to improve the insertion time

Hello all,

I have the following script

Insert into ZZ
Select a.*, b.*
From XX a, YY b
Where a.xx=b.xx

Table XX and YY contains about 1.2M records
Running this script takes about 3hours.
Can any body advice me on what to do to improve/reduce the execution
time.
Thank you.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

Oracle LazyDBA home page