Update Problem

[Mohammad]

Hi

I have this query to update some records in my table. It is working
good but my problem is this query very slow. Is any way to do this job
faster.

UPDATE SWKPIFA Y
SET Y.SWKPIFA_TRAN_ CODE = 'G'
WHERE SWKPIFA_START_T ERM =
( SELECT MIN(X.SWKPIFA_S TART_TERM)
FROM SWKPIFA X
WHERE Y.SWKPIFA_PIDM = x.SWKPIFA_PIDM
AND Y.SWKPIFA_MAJR_ CODE = X.SWKPIFA_MAJR_ CODE)
AND SWKPIFA_END_TER M =
( SELECT MAX(X.SWKPIFA_E ND_TERM)
FROM SWKPIFA X
WHERE Y.SWKPIFA_PIDM = x.SWKPIFA_PIDM
AND Y.SWKPIFA_MAJR_ CODE = X.SWKPIFA_MAJR_ CODE)
/

Thanks
Hakim