-- ABS-3591 connection time out when running report 'Inventory Usage' ABS-5994

CREATE INDEX XIE5WEARERINVENTORY ON WEARERINVENTORY (WEAREREMPLOYMENT_ID, DATEACTIVE, DATEINACTIVE);

CREATE INDEX XIE3ISSUEHISTORY ON ISSUEHISTORY (PROCESSBUSINESSUNIT_ID, WEAREREMPLOYMENT_LINK_ID, TRUNC(INCIRCDATE));

CREATE INDEX XIE4OUTOFCIRCULATIONHISTORY ON OUTOFCIRCULATIONHISTORY (PROCESSBUSINESSUNIT_ID, WEAREREMPLOYMENT_LINK_ID, TRUNC(OUTOFCIRCDATE));

CREATE INDEX XIE6DELIVERYSCAN ON DELIVERYSCAN (UNIQUEITEM_LINK_ID, WEAREREMPLOYMENT_LINK_ID, NVL(PACKINGNOTE_ID,0));
