Performance Tuning Tips For Archive

SELECT DISTINCT  	DI.MAINT_​​OBJ_​​CD,
MO.TBL_​​NAME,
CF.CONST_​​ID,
CF.SEQ_​​NUM,
CF.FLD_​​NAME
FROM	CI_​​DB_​​INSTR DI,
CI_​​MD_​​MO_​​TBL MO,
CI_​​MD_​​CONST CO,
CI_​​MD_​​CONST_​​FLD CF
WHERE DI.DB_​​PROC_​​CD = <input DB Process Code>
AND MO.MAINT_​​OBJ_​​CD = DI.MAINT_​​OBJ_​​CD
AND CO.TBL_​​NAME = MO.TBL_​​NAME
AND CO.REF_​​CONST_​​ID IN (SELECT C2.CONST_​​ID FROM CI_​​MD_​​CONST C2 WHERE C2.TBL_​​NAME = CO.TBL_​​NAME)
AND CO.CONST_​​ID = CF.CONST_​​ID
 	AND CO.CONST_​​ID NOT IN (SELECT MDT.PRNT_​​CONST_​​ID FROM CI_​​MD_​​MO_​​TBL MDT WHERE MDT.MAINT_​​OBJ_​​CD = MO.MAINT_​​OBJ_​​CD)
AND CO.CONST_​​ID NOT IN (SELECT DPP.LNKG_​​CONST_​​ID FROM CI_​​DB_​​INSTR DPP WHERE DPP.DB_​​PROC_​​CD = DI.DB_​​PROC_​​CD)ORDER BY 1,2,3