/* Index list for performance received from PVD */

-- Installed at ANG for performance
begin
execute immediate ('
create index XSPEEDDELIVERYVARIATIONS on DELIVERYVARIATIONS (PROCESSED, DISTRIBUTIONPOINT_ID, PACKINGNOTE_ID) tablespace INDX storage ( maxextents unlimited );
create index XSPEEDPRODUCT on PRODUCT (PACKINGSEQUENCE, CODE, PRODUCT_ID) tablespace INDX storage ( maxextents unlimited );
create index XSPEEDDELIVERYHISTORY on DELIVERYHISTORY (distributionpoint_link_id, deliverydate) tablespace INDX storage ( maxextents unlimited );
create index XSPEEDINVOICEHEADERBILLT on INVOICEHEADER (INVOICEBUSINESSUNIT_ID, BILLTOCUSTOMERNUMBER, INVOICEDATE) tablespace INDX storage ( maxextents unlimited );
') ;
exception when others then null;
end;
/