Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Rushmore question
Message
De
29/07/2001 13:02:55
Nancy Folsom
Pixel Dust Industries
Washington, États-Unis
 
 
À
29/07/2001 11:33:09
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00536979
Message ID:
00536998
Vues:
5
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform