-- Create/Recreate indexes 
create index XINDX_I_RESIDENTIALPLPC_PROD on I_RESIDENTIALPLPC (productcode, typeofmerchandise);
create index XINDX_I_RESIDENTIALPLPC_CUST on I_RESIDENTIALPLPC (customernumber);
