-- ABS-58575/ ABS-58672

CREATE INDEX XIE3STOP ON STOP (CUSTOMER_LINK_ID ASC, NVL(ROUTESTOP_ID,0) ASC, STOPTYPE ASC, ROUTECONTROL_ID ASC);

CREATE INDEX XIE7DELIVERYSCAN ON DELIVERYSCAN (DISTRIBUTIONPOINT_LINK_ID ASC, OUTSCANNODELIVERY ASC, WEAREREMPLOYMENT_LINK_ID ASC);
