Hi Philip,

Try to disable table ZZ index.

And after insert complete , rebuild ZZ index

Regards
Wilson

-----Original Message-----
From: Philip Otunla
Sent: Monday, July 30, 2007 11:29 PM
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