Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL: where vs. join
Message
From
10/08/2009 13:43:22
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01416873
Message ID:
01417143
Views:
79
Hi Naomi,
>There should not be difference in performance, IMHO, but I would always prefer JOIN syntax over WHERE syntax for better readability.
>
>Also JOIN and WHERE behave differently, JOIN happens first, then WHERE.

Nope. Filtering normally comes first to speed up by reducing set size (usually the where clause) and then the join-operation.
If there is a filter in the join condition SOMETIMES this is also executed during the first step (depends on the smarts of the engine).

regards
thomas
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform