What's tables codepage and current code page? If CPCURRENT() and CPDBF()don't match, Russhmore will be disabled in VFP9 for such table.
What indexes do you've on those tables?

>
>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?