Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index should be fully optmized
Message
From
05/11/2006 12:40:23
 
 
To
04/11/2006 21:57:33
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01167140
Message ID:
01167188
Views:
7
>>If you didn't need the deleted() tag before you might check that creating it for that particular query doesn't slow down other queries. No really *good* choices here, but still you can try to find the lesser evil.
>
>The result is significant when having it. It is really slow without it so I guess I will have to request the addition of that tag on the production table.

Make sure that you use a binary index on deleted(), a binary index is much smaller and more efficient.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform