>>>>Thank you. Is there a function that shows if my SQL Select is Rushmore optimized?
>>>>
>>>I don't think so. BTW, it's not advisable to use Order as a field name.
>>>
>>>You can probably test by removing the index and measure time and put index back and measure time again.
>>
>>What is wrong with using Field Name in the Order expression? Would using column number speed up the execution?
>
>No, I meant that Order is a reserved word in VFP and therefore it's better to avoid it as a field name. You can use SortOrder instead as a field name.
I see now. It was just a typo in my initial statement. I don't have a column named "Order". Sorry for the confusion.
"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