Hi All,

This was fully optimized with VFP8:

SELECT Distinct Sofe301.prgrupp,;
                Sofe301.namn,;
                Sofe110.opnr,;
                Sofe110.ejbelagg;
                FROM sofe110;
                INNER JOIN sofe301;
                ON  sofe110.prgrupp = Sofe301.prgrupp;
                WHERE SUBSTR(Sofe301.artnr,11,8) =  ?vp_artnum  AND;
                Sofe110.ejbelagg = 'J' ;
                ORDER BY Sofe110.opnr into cursor crsOpnr

Using index tag Ejbelagg to rushmore optimize table sofe110
Rushmore optimization level for table sofe110: full
Using index tag Subartnr to rushmore optimize table sofe301
Rushmore optimization level for table sofe301: full
Joining table sofe301 and table sofe110 using index tag Opprgr

But with VFP9 it is not:

Rushmore optimization level for table sofe110: none
Rushmore optimization level for table sofe301: none
Joining table sofe110 and table sofe301 using temp index

Can anyone please tell me the reason for this?