Update Problem

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 Received on Fri Dec 12 2003 - 09:49:09 CST