>>
>>IMHO, Rushmore is about 'Where' expressions, i.e. field list is rushmore-irrelevant. I think, the first internal step is collect all records by joint criteria (here Rushmore used), and then Fox looks at field list.
>
>OK,
>but I my opinion Rushmore SHOULD be about using existing indexes to achieve the fastest query performance possible.

Is it something different? :)

>To ignore UNIQUE index tags is a waste and to be able to beat the performance of SQL by an order of magnitude
>with old style xbase code is crazy.

Do you have deleted records in your table that has UNIQUE indexes?

Vlad