Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What's the differences between nested and sub join query
Message
 
 
To
07/05/2004 05:58:43
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00901574
Message ID:
00901938
Views:
12
Fabio,

>on a SELECT command is the ON clause that fixed the evaluation order;
>read the ON in left to right order and you can known the evaluation order.

Your statement is incorrect. The VFP SQL optimizer will use it's own internal rules to determine the optimal order to join the tables. Sometimes the optimizer is not as smart as the developer that has apriori knowledge about the data that can improve the performance, thus they added the FORCE clause.

A quote from help:

[FORCE] DatabaseName!
Lists the tables containing the data that the query retrieves.
FORCE specifies that tables are joined in the order in which they appear in the FROM clause. If FORCE is omitted, Visual FoxPro attempts to optimize the query. However, the query might be executed faster by including the FORCE keyword to disable the Visual FoxPro query optimization.
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