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_TERM =
( SELECT MIN(X.SWKPIFA_START_TERM)
FROM SWKPIFA X
WHERE Y.SWKPIFA_PIDM = x.SWKPIFA_PIDM
AND Y.SWKPIFA_MAJR_CODE = X.SWKPIFA_MAJR_CODE)
AND SWKPIFA_END_TERM =
( SELECT MAX(X.SWKPIFA_END_TERM)
FROM SWKPIFA X
WHERE Y.SWKPIFA_PIDM = x.SWKPIFA_PIDM
AND Y.SWKPIFA_MAJR_CODE = X.SWKPIFA_MAJR_CODE)
/

Thanks
Hakim