>Hi,
>
>I am testing the level or Rushmore optimization for the following SQL Select:
>
>
>SYS(3054,11)
>select top 100 MyField1, MyField2, MyField3, MyField3 order from MyTable order by MyField1
>
>
>The result show that the level of optimization is None. The table MyTable does have an index tag on MyField1. What am I missing in making this query Rushmore optimized?
>
>TIA.
vfp doesn't optimize ORDER BY and GROUP BY