Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can't optimize SQL in vfp5?
Message
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Can't optimize SQL in vfp5?
Miscellaneous
Thread ID:
00046681
Message ID:
00046681
Views:
79
Using sys(3054), optimize on, most queries I try, even the simplest, show "None" for optimization level (occasionally I get a "Partial"). I hadn't noticed this problem until a large table query was very slow; the same queries under 2.6 work very quickly. Apparently pre-built indexes are not being picked up in vfp5...

Any ideas?
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Next
Reply
Map
View

Click here to load this message in the networking platform