Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP6.0 Optimize SQL
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00352764
Message ID:
00352804
Views:
12
> 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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform