DB_LINK 썸네일형 리스트형 [오라클] 쿼리가 느려요? DB_LINK 테이블 서브쿼리로 JOIN SELECT A.TYPE_CD, A.TYPE_NAME, B.FORM_CD, B.FORM_NAME, 0 AS CHK FROM TF_APP_TYPE_CD A LEFT OUTER JOIN TF_APP_FORM_CD B ON A.TYPE_CD = B.TYPE_CD WHERE 1 = 1 AND A.USE_YN = '1' AND B.USE_YN = '1' AND A.TYPE_CD || B.FORM_CD NOT IN ( SELECT SUB.TYPE_CD || SUB.FORM_CD FROM TF_APP_FIN_CHR_SETUP SUB LEFT OUTER JOIN VW_FIN_DEPT_LEVEL SUB2 ON SUB.DEPT_CD = SUB2.DEPT_CD WHERE 1 = 1 AND SUB2.DEPT_CD IS NOT.. 더보기 이전 1 다음