>>
>>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement