Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>>If I have an index on UPPER(Field) and then do a LOCATE FOR UPPER(Field) = lcField, does Rushmore take advantage of that index?
>>
>>Check in the help under Rushmore. You should find an entry about Rusmore optimizable expression.
>>
>>Also, look at the SYS(3054) which will tell you exactly how Rushmore is being used. It's not always safe to assume something is being optimized. Nor is always safe to assume you _want_ optimization.
>
>The SYS(3054) shows optimization levels for queries only.
Yes, of course. Sorry, it was a knee jerk reaction that crept in after the help file comment. Thanks for the catch.
Précédent
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