-- ABS-35936
CREATE INDEX XIF1WASHINGPROCESSALTERNATIVE ON WASHINGPROCESSALTERNATIVE (WASHINGPROCESS_ID ASC);
CREATE INDEX XIF2WASHINGPROCESSALTERNATIVE ON WASHINGPROCESSALTERNATIVE (ALTERNATIVEWASHINGPROCESS_ID ASC);

-- ABS-30100
CREATE INDEX XIF1PICKEDUPCONTAINERS ON PICKEDUPCONTAINERS (DISTRIBUTIONPOINT_LINK_ID ASC);
CREATE INDEX XIF2PICKEDUPCONTAINERS ON PICKEDUPCONTAINERS (STOP_ID ASC);
CREATE INDEX XIF3PICKEDUPCONTAINERS ON PICKEDUPCONTAINERS (CONTAINERTYPE_ID ASC);

-- ABS-35937
CREATE INDEX XIF1MACHINE ON MACHINE (PLANT_ID ASC);
CREATE INDEX XIF2MACHINE ON MACHINE (MACHINETYPE_ID ASC);

CREATE INDEX XIF1MACHINECOMPARTMENT ON MACHINECOMPARTMENT (MACHINE_ID ASC);

CREATE INDEX XIF1MACHINECOMPARTMENTLIMIT ON MACHINECOMPARTMENTLIMIT (MACHINECOMPARTMENT_ID ASC);

--ABS-7437
CREATE INDEX XIF1PRODUCTIONPROCESSBUFFER ON PRODUCTIONPROCESSBUFFER (PLANT_ID ASC);

CREATE INDEX XIF11WORKSTATION ON WORKSTATION (PRODUCTIONPROCESSBUFFER_ID ASC);

CREATE INDEX XIF1PLANTOPERATINGHOURS ON PLANTOPERATINGHOURS (PLANT_ID ASC);
CREATE INDEX XIF2PLANTOPERATINGHOURS ON PLANTOPERATINGHOURS (DAY_ID ASC);
