Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing and Joins
Message
From
07/08/2001 13:23:55
 
 
To
07/08/2001 10:09:28
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00540551
Message ID:
00540802
Views:
11
>Do you happen to know - or have a guess - what criteria VFP would use to use or reject an index?

I've seen it reject an index when the index was on a small table being joined to a much larger table. Rushmore chooses to create a temp index on the larger table (usually an intermediate result in a join).

Tamar
Previous
Reply
Map
View

Click here to load this message in the networking platform