[thelist] [sql] location of conditional
Joshua Olson
joshua at waetech.com
Mon Aug 4 21:35:57 CDT 2003
No... :-( I was hoping you'd enlighten me.
Now that I think of it, it wouldn't make a difference in INNER JOINS except
that it might dictate what order the db engine actually does the filtering,
which could make a profound difference depending on the indexes and the
percentage of rows to be excluded. I guess a good optimizer would make this
a moot point.
It seems, though, that in an OUTER join the location of the conditional
could make a big difference? Wrong? Right?
-joshua
----- Original Message -----
From: "rudy" <rudy937 at rogers.com>
Sent: Monday, August 04, 2003 10:25 PM
> they're equivalent
>
> have you run them through EXPLAINs for performance differences?
More information about the thelist
mailing list