3 Replies Latest reply: Nov 13, 2012 10:16 PM by 894936 RSS

    I need to Tune Query.

    894936
      Hi Team,
      could you please tell me how to tune the below query.
      UPDATE OBSERVATION_T
      SET     OBS_NOOBSDOC=
              (
                      SELECT  COUNT(*)
                      FROM    OBSERVATION_DOC_T od
                      WHERE   od.SEQ_NO_OBS            =:1
                              AND od.OBS_SEVERITY NOT IN('K','X')
              )
              ,
              UPD_DATE    =:2          ,
              VERSION_NO  =VERSION_NO+1,
              OBS_SEVERITY=:3          ,
              OBS_CORRSTAT=:4          ,
              OBS_MESSAGE =:5
      WHERE   SEQ_NO_OBS  =:6