General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only