Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is normal this Speed?
Message
From
08/05/2003 14:34:51
 
 
To
08/05/2003 10:30:12
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00784121
Message ID:
00786414
Views:
16
>>Hilmar,
>>I'm actually using "Not deleted()" as my tag instead of "deleted()". Is there any difference.
>>Yau
>
>I am not sure. But I think the index will be used anyway (which isn't always appropriate - see my FAQ), because the implicit condition, if you have SET DELETED ON, is ... AND NOT DELETED(). In other words, the index tag exactly matches the expression.
>
>If you need your index for other purposes (besides "optimization"), there are ways to avoid VFP using it.
>
>Hilmar.

Using NOT in a tag means that Rushmore can't use it for optimization.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform