Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What is the best index expression?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01005870
Message ID:
01005896
Views:
14
>Hi everybody,
>
>If I want to filter all non-empty values for character (100) field, what would be the best expression for the index (if I need the index)?
>
>Thanks in advance.


I don't know if this is a best solution:
INDEX ON MyField FOR !EMPTY(MyField) TAG TableTag
SET ORDER TO TableTag
BROW
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform