2 Replies Latest reply: May 10, 2012 8:03 AM by Centinul RSS

    Tuning the Query -- Please advise

    554924
      Dear All,

      Please advise how to tune this query

      SELECT COUNT(gvr.rotation_no)
      FROM xvy gvch,
      abc gvm,
      qwa gvr
      WHERE GVM.VESL_MASTER_NUM =GVR.VESL_MASTER_NUM
      AND GVR.ROTATION_NO(+) = GVCH.ROTATION_NO
      AND (P_ROTATION_NO IS NULL
      OR GVCH.ROTATION_NO LIKE '' || P_ROTATION_NO || '%')
      AND (P_CM_REGN_NO IS NULL
      OR UPPER(GVR.CM_REGN_NO) LIKE '' ||UPPER(P_CM_REGN_NO)||'%')
      AND (P_VESL_NAME IS NULL
      OR UPPER(GVM.VESL_NAME) LIKE '' ||UPPER(P_VESL_NAME)||'%')
      AND (P_VESL_NO IS NULL
      OR UPPER(GVM.VESL_NO) LIKE '' ||UPPER(P_VESL_NO)||'%')

      Regards,
      YKING