Slow performance while Update Existing Rows only

senthilmp · Post by **senthilmp** » Wed Dec 10, 2008 6:00 am

Hi,

One of our job is processing only 5 rows per second, we have nearly 0.23 million source records and the update rule in the target is 'update existing rows only'.Can anyone pls help me out how to improve the performance of this jobs. i have disabled the index and constraints on the target table, but still getting 5 rows per second only.

balajisr · Post by **balajisr** » Wed Dec 10, 2008 6:34 am

Do you have an index on the key column? Disabling index in this case will slow down your job.

senthilmp · Post by **senthilmp** » Wed Dec 10, 2008 6:40 am

No i dont have indexcon the key column, do you suggest to create one?

balajisr · Post by **balajisr** » Wed Dec 10, 2008 6:50 am

senthilmp wrote:No i dont have indexcon the key column, do you suggest to create one?

Yes.

senthilmp · Post by **senthilmp** » Wed Dec 10, 2008 7:14 am

Thansk it works