>>Using index tag Ejbelagg to rushmore optimize table sofe110 >>Rushmore optimization level for table sofe110: partial >>Using index tag Subartnr to rushmore optimize table sofe301 >>Rushmore optimization level for table sofe301: partial >>Joining table sofe301 and table sofe110 using index tag Opprgr >>>>
>>Index for Sofe301.dbf: >>Tag: Key: >>RADNR SUBSTR(ARTNR,11,8)+STR(RADNR) >>RADTYP1 ARTNR+RADTYP >>RADTYP2 SUBSTR(ARTNR,11,5)+RADTYP >>PRGRUPP ARTNR+PRGRUPP >>RADNR2 ARTNR+STR(RADNR) >>RADTYP RADTYP+SUBSTR(NAMN,1,18) >>RADNR3 SUBSTR(ARTNR,11,5)+STR(RADNR) >>SUBARTNR SUBSTR(ARTNR,11,8) >>PRGRUPP2 PRGRUPP >> >>Index for Sofe110.dbf: >>Tag: Key: >>OPNR OPNR >>OPPRGR PRGRUPP >>OPPRAV PRAVSN >>EJBELAGG EJBELAGG >> >>