The SYS(3054) can only report on WHERE and JOIN optimization. I'm not sure if VFP is capable of optimizing anything else.

>
>When I try the following SQL Select
>
>

>select top 100 * from mytable order by pkfield desc
>

>
>the SYS(3054) reports Rushmore optimization as None.
>
>How can I change the expression to be Rushmore optimized?
>
>TIA.