>>but I my opinion Rushmore SHOULD be about using existing indexes to achieve the fastest query performance possible.
>
>
>>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
Sometimes I have deleted records - other times not. Also, when there might be deleted records, I add the FOR NOT DELETED() to the tag.