Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Best way to index
Message
De
05/04/2000 18:50:04
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00355970
Message ID:
00355974
Vues:
19
Whoops, forgot. Using Upper is a good rule of thumb. Even if you don't captialize the company name during data entry, If the index is on Upper(compname), you can find all the "ABC COMPANY".

pf

>Is there a rule of thumb to follow when using index expressions? Is it common to index on something like Upper(AllTrim(FieldName))? Are there performance issues in doing this?
>Any thoughts?
>TIA

(On an infant's shirt): Already smarter than Bush
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform