[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