Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP6.0 Optimize SQL
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00352764
Message ID:
00352804
Vues:
13
> About Booleans: use explicit logical field =.t. or logical field = .f. in your SQL to make it Rushmore optimizable, if you have an Index on this logical field.

I meant Boolean operators, AND, OR, NOT...not T/F as in some languages.

And no offense, Nadya, but that may be the worst thing to do. Putting indexes on logicals means often carrying large chunks of the index across the wire...so in a WAN or RAS especially, that may not be a good way to go. The VFP Rushmore Help is woefully lacking in this area, as the discovery of this problem is fairly recent...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform