
begin
execute immediate ('create index XTESTINVOICEHEADER on INVOICEHEADER (CREDITEDINVOICEHEADER_ID, STATUS_ID);
create index XTESTISSUEHISTORY on ISSUEHISTORY (CUSTOMER_LINK_ID, ASSIGNDATE, INVOICEHEADER_ID);
create index XTESTOUTOFCIRCULATIONHISTORY on OUTOFCIRCULATIONHISTORY (CUSTOMER_LINK_ID, TRUNC(OUTOFCIRCDATE), CHARGETYPE, INVOICEHEADER_ID);
create index XTESTPACKINGNOTE on PACKINGNOTE (DISTRIBUTIONPOINT_ID, DELIVERYDATE, STATUS_ID, ORIGIN);
create index XTESTPRINTQUEUE on PRINTQUEUE (PROCESSED, TRUNC(CREATIONDATE), INVOICEHEADER_ID, LABELLAYOUT_ID, WEAREREMPLOYMENT_LINK_ID, CUSTOMER_LINK_ID);
create index XTESTREPAIRHISTORY on REPAIRHISTORY ( CUSTOMER_LINK_ID, TRUNC(REPAIRDATE), INVOICEHEADER_ID );
create index XTESTSQWEARER on SQWEARER (STATUSQUOHEADER_ID, CUSTOMER_LINK_ID);') ;
exception when others then null;
end;
/