>Andrzej,
>
>I would say it was NOT optimized.
>
>I forget the details, but possibly Rushmore does not bother on tables of small size???
>
>Regards,
>Jim N.
>
>>>>One other thing. Based on my recent playing with the sys(3054) it appears that you turn on the function, run the query and check to see if the query was optimized. In other words, you are only able to gauge the Rushmoreness after the query has run. That's where I got my interpretation .
>>
>>My question is base on that assumption. As was stated earlier in this thread, it simplest query on simplest tables with obvious indexes. Just two tables join.
>>
>>So, joining is optimized or not?

Rushmore only optimizes filter conditions. So a query that says UPPER(LASTNAME)="YEARWOOD" would optimize if an index on UPPER(LASTNAME) exists. The join probably isn't considered as a filter.

Mike Yearwood, Toronto Ontario Canada (co-founder of the Toronto Foxpro User's Group)