Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is normal this Speed?
Message
From
09/05/2003 15:54:16
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:
00786931
Views:
32
>>>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.

Even if the expression explicitly says "NOT Something"? Perhaps, I am not sure.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform