Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
System hangs on a simple select statement
Message
 
 
To
31/03/2000 08:05:11
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00352912
Message ID:
00353288
Views:
22
Bill,

>Could this case be tested with a SELECT NOOPTIMIZE ... ?

I'm not sure. Even if VFP is told to not use the index to help it select records it might try to use the index to provide support for an ORDER BY clause. I've usually been so ticked that the CDX has corrupted on a production table that additional testing isn't a high priority.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform