Page 1 of 1

update on table giving me low performance

Posted: Wed Jul 09, 2008 7:43 am
by basu.ds
Hi
I am trying to update table but it is taking more time.how can i tune this job it is only update.i have 150000 recordr are there in my input.

thanks in advance

Posted: Wed Jul 09, 2008 7:49 am
by chulett
Not a lot of information to work on. I'd guess you don't have an index over the key fields and thus each update is a full table scan until found. :?