Project Instance List

[Sunny, Park]

---------------------------> Inner JOIN 최적화 쿼리

SELECT DISTINCT PJ.PJ_NAME 프로젝트명, PJ.PJ_INFO 프로젝트정보, PJ.PJ_REG_DATE 프로젝
트생성일시,
I.IN_NAME 어댑터이름, I.IN_REG_DATE 어댑터생성일시, I.IN_INFO 어댑터정보,
I.IN_DEPLOY_CK 디플로이여부, I.IN_DEPLOY_DATE 디플로이일시, I.IN_START_XMS,
I.IN_START_XMX, I.IN_COMPILER_OPT, I.IN_AUTOSTART_CK,
I.IN_AUTOSTART_CNT,
RS.RS_SAVE_PATH, RS.RS_REG_DATE 클래스등록일시, RS.RS_NAME 클래스명, RS.RS_TYPE
RSTYPE, RS.RS_SIZE 사이즈,
PD.PD_ID PDID, PJ.PJ_ID PJID, I.IN_ID INID, RS.RS_ID RSID, I.IN_TYPE
INTYPE, I.IN_MC_TYPE INMCTYPE
FROM PROJECT PJ
INNER JOIN INSTANCE_MAP INP ON INP.PJ_ID = PJ.PJ_ID
INNER JOIN instance_list I ON I.IN_ID = INP.IN_ID
INNER JOIN DEPLOY_MAP DPM ON I.IN_ID = DPM.IN_ID
INNER JOIN resources RS ON RS.RS_ID = DPM.RS_ID AND RS.RS_USE='Y' AND
RS.RS_TYPE='AD_CU_CLS'
INNER JOIN PRODUCT PD ON I.PD_ID = PD.PD_ID


ORDER BY 프로젝트명, INTYPE, INMCTYPE, 어댑터이름, RSTYPE, 클래스명