

ALTER TABLE t_tracking_info ADD INDEX U_POSCH_DT (unit_id, po_schedule_id, DATE);
ALTER TABLE t_tracking_info ADD INDEX U_DT_POSCH (unit_id, DATE, po_schedule_id);


ALTER TABLE m_schedule ADD INDEX U_POH(unit_id, po_header_id);
ALTER TABLE m_po_line ADD INDEX U_POH(unit_id, po_header_id);

ALTER TABLE dc ADD INDEX DCNO(dc_no);

