Re: Request: Support for __JOIN(c1.fkey c2)__

[prev] [thread] [next] [Date index for 2005/05/04]

On 04 May 2005 11:59:52 -0700, Randal L. Schwartz <merlyn@xxxxxxxxxx.xxx> w=
rote:
> And while you're in there dinkin' with that code, some support for
> various joins in the FROM section would be nice too.
>
> I'm slowly coming around to the notion that all joins should be listed
> in FROM, reserving WHERE for strictly things that are reducing the
> table set.  If I'm missing something, let me know.

Amen! I believe on some platforms (MSSQL), joins in the FROM have a
better chance of getting a better query plan and joins in the WHERE,
and possible the query plan can be better cached since two queries
with the same FROM joins but different WHERE clauses are the same
query minus the additional fintering.

Of course, I could be full of it.

-=3DChris