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:
00352852
Views:
10
> Thanks for the tip, Bruce. AFAIK we don't use indexes on logical fields except for deleted().

Uh-oh...that's the worst one of all :) (according to the new school of thought on indexing, at least). If you have a lot of deleted records, of course, it still makes sense to have it, or if you don't do SQL to unfiltered output.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Previous
Reply
Map
View

Click here to load this message in the networking platform