update on table giving me low performance

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
basu.ds
Participant
Posts: 118
Joined: Tue Feb 06, 2007 12:59 am
Location: Bangalore

update on table giving me low performance

Post 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
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post 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. :?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply