Thank you. Is there a function that shows if my SQL Select is Rushmore optimized?
>The SYS(3054) only shows optimizations for WHERE and JOIN conditions
>
>>
>>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.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
