Performance issue of a job
Posted: Tue Dec 27, 2005 1:36 pm
Hi Friends
I did a job in which i have to either update the table or insert into the table(Oracle). My job has 3 hashed files. First Hashed file does the lookup and based on it, it either updates or inserts in to the same hashed file. The other two hashed files does the look up and if not found it just inserts.
Here is my problem, when i run the job it is so slow that it is taking too long to finish. The performance is really bad. I dont have any clue
Can anybody help me on this
ps:Target table has indexes.
Does anybody have any suggestions.
thanks
regards
Aakash
I did a job in which i have to either update the table or insert into the table(Oracle). My job has 3 hashed files. First Hashed file does the lookup and based on it, it either updates or inserts in to the same hashed file. The other two hashed files does the look up and if not found it just inserts.
Here is my problem, when i run the job it is so slow that it is taking too long to finish. The performance is really bad. I dont have any clue
Can anybody help me on this
ps:Target table has indexes.
Does anybody have any suggestions.
thanks
regards
Aakash