Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is normal this Speed?
Message
De
09/05/2003 15:54:16
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
08/05/2003 14:34:51
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00784121
Message ID:
00786931
Vues:
30
>>>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)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform