>>>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.
Ok, this is correct. I asked you because I was not sure that you're aware that you need the FOR NOT DELETED() clause.
As for the use of UNIQUE indexes in Rushmore optimizations for SELECT-SQL: I see only one very special case when they could be used:
SELECT TagExpr AS AField DISTINCT FROM ATable
where the TagExpr is the expression of the UNIQUE index.
I don't see any other case when they could be used for optimizations. Something similar goes for the indexes with a FOR clause.
Am I right?
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