Re: Strange problem.

Chuck <skilover_nospam_at_bluebottle.com> wrote in news:1133889203.ba727e1adc34c4abde94a39bd7453edb_at_news.nntpserver.com:

> I have an update that I'm trying to optimize.
>
> UPDATE PS_TL_PAYABLE_TIME
> SET PAYABLE_STATUS = 'RP'
> WHERE PAY_SYSTEM = 'NA'
> AND PAYABLE_STATUS NOT IN ('PD', 'DL')
> AND PAYROLL_REQ_NUM <> 1
> AND EXISTS (
> SELECT 'X'
> FROM PS_TL_XREF_TBL A, PS_PY_XREF_WRK B
> WHERE A.PAY_SYSTEM = 'NA'
> AND A.SEQ_NBR = PS_TL_PAYABLE_TIME.SEQ_NBR
> AND B.XREF_NUM = A.XREF_NUM
> AND B.PROCESS_INSTANCE = :1)
 UPDATE PS_TL_PAYABLE_TIME
    SET PAYABLE_STATUS = 'RP'
  WHERE PAY_SYSTEM = 'NA'
    AND PAYABLE_STATUS NOT IN ('PD', 'DL')     AND PAYROLL_REQ_NUM <> 1
    AND EXISTS (

           SELECT 'X'
             FROM PS_TL_XREF_TBL A,
            WHERE A.PAY_SYSTEM = 'NA'
              AND A.SEQ_NBR = PS_TL_PAYABLE_TIME.SEQ_NBR
              AND A.XREF_NUM in (SELECT B.XREF_NUM FROM  PS_PY_XREF_WRK B
                                 WHERE B.PROCESS_INSTANCE = :1
                                )
                )