

create index producer_homepage on producer (homepage)
;
create index producer_country on producer (country)
;


create index product_lbl on product (label)
;
create unique index product_producer_nr on product (producer, nr)
;
create index product_pn1 on product (propertynum1)
;
create index product_pn2 on product (propertynum2)
;
create index product_pn3 on product (propertynum3)
;

create index ptype_inv on producttypeproduct (producttype, product)
;

create index pfeature_inv on productfeatureproduct (productfeature, product)
;

create index vendor_country on vendor (country)
;
create index vendor_homepage on vendor (homepage)
;

create unique index offer_producer_product on offer (producer, product, nr)
;
create index offer_validto on offer (validto)
;
create index offer_vendor_product on offer (vendor, product)
;
create index offer_webpage on offer (offerwebpage)
;

create unique index review_product on review (product, producer, nr)
;

create index review_person on review (person)
;

create unique index review_product_person_producer on review (product, person, producer, nr)
;

create unique index review_producer_product on Review (producer, product, nr)
;

create  index review_textlang on Review (textlang)
;






