Oracle SQL Update query takes days to update
Posted
by B Senthil Kumar
on Stack Overflow
See other posts from Stack Overflow
or by B Senthil Kumar
Published on 2010-06-01T05:24:17Z
Indexed on
2010/06/01
5:33 UTC
Read the original article
Hit count: 257
I am trying to update a record in the target table based on the record coming in from source. For instance, if the incoming record is present in the target table I would update them in the target else I would simply insert. I have over one million records in my source while my target has 46 million records. The target table is partitioned based on calendar key. I implement this whole logic using Informatica. I find that the Informatica code is perfectly fine looking at the Informatica session log but its in the update it takes long time (more than 5 days to update one million records).
Any suggestions as to what can be done on the scenario to improve the performance?
© Stack Overflow or respective owner