[thesite] faster queries on new w.e.o
rudy
r937 at interlog.com
Tue May 22 18:35:18 CDT 2001
>... if tables come out with the same weight,
> the last one listed will be used first.
ya learn sumpin every day
here i thought all along that all things being equal, tables are joined
left to right in the order that they are mentioned -- wait a sec, is that
what you mean by "used first"? they are joined left to right so the
rightmost one is retrieved first?
"all things being equal" of course means the old-fashioned way of listing
the tables -- if you use the JOIN syntax, especially with parentheses, you
have much greater influence on execution sequence...
iirc, afaik, imho, and ymmv
rudy
More information about the thesite
mailing list