Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index should be fully optmized
Message
From
04/11/2006 21:28:16
 
 
To
04/11/2006 17:30:04
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:
01167163
Views:
8
>There are no tag on DELETED(). I see that as soon as I put the tag on it, it went fast. This table comes from a remote location. So, I will have to ask them to add a tag there. But, usually, I don't have a need anymore to use this tag. I have found that since a few versions of VFP, that this doesn't change anything as far as optimization goes.
>
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.

regards

thomas
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform