The first and foremost thing you can do is pass hint for indexes existing in
XX, YY, in the select query.
Select a.*, b.* with (index (a.id)) from XX a, YY b where a.xx=b.xx
This will reduce execution time of select query. Provided it is used
judiciously, because index hint will override the query optimizer.

Thank you,

Sincerely,
Pawan Kumar,
Phone: +91-120-4363300 x2761
-----Original Message-----
From: Philip Otunla
[mailto:oracledba-ezmlmshield-x15503725.[Email address protected]
Sent: Monday, July 30, 2007 8:59 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