  dbms_output.put_line(' map DesignElementAccessions to existing genes: ' || TO_CHAR(sysdate, 'HH24:MI:SS'));
 
  --add accessions for non-existing genes
- Insert into tmp_DesignElementMap(designelementaccession,GeneID,GeneIdentifier)
+ Insert /*+ _parallel(tmp_DesignElementMap, 12) append */ into tmp_DesignElementMap(designelementaccession,GeneID,GeneIdentifier)
  select Accession, null, EntryValue
  from (
  select t.Accession, EntryValue, RowNum r 

 dbms_output.put_line(' update propertyvalues: ' || TO_CHAR(sysdate, 'HH24:MI:SS'));
 
 --map DesignElementAccessions to existing genes
 Insert into tmp_DesignElementMap(DesignElementAccession,GeneID,GeneIdentifier)
 select t.Accession, min(GeneID), null
 from table(CAST(LowerCaseDesignElements as DesignElementTable)) t
 join vwGeneIDs IDs on ids.name = t.EntryName and ids.value = t.EntryValue

 dbms_output.put_line(' update properties: ' || TO_CHAR(sysdate, 'HH24:MI:SS'));
 
 --update propertyvalues
 MERGE /*+ parallel(a2_GenePropertyValue,10) append */ into a2_GenePropertyValue p
 USING (select distinct p.GenePropertyID, EntryName, EntryValue 
        from table(CAST(LowerCaseDesignElements as DesignElementTable)) d 
        join a2_GeneProperty p on p.Name = d.EntryName
