Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Best way to index
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00355970
Message ID:
00356134
Views:
15
>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

Alan, I never do neither Upper nor trim in index expressions, So I have a text boz class that always have the fields in uppercase.
Pablo Roca
Clavo Congelados, S.A. (La Coruna - Spain)
Sysop of PortalFox

Join MasFoxPro campaign
http://www.masfoxpro.com
Previous
Reply
Map
View

Click here to load this message in the networking platform