There is nothing in your query that you can optimize. It doesn't use an index as there is no FOR or JOIN clause.

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