pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedquestion on JOIN and WHERE clause
2+ messages / 2 participants
[nested] [flat]
* question on JOIN and WHERE clause
@ 2002-05-30 17:07 Wei Weng <wweng@kencast.com>
0 siblings, 0 replies; 2+ messages in thread
From: Wei Weng @ 2002-05-30 17:07 UTC (permalink / raw)
To: pgsql-sql
Does the SQL optimizer process the JOIN first then add WHERE
constraintson it or it processes the WHERE clause and JOIN at the same
time?
Thanks!
--
Wei Weng
Network Software Engineer
KenCast Inc.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: question on JOIN and WHERE clause
@ 2002-05-31 08:50 Henshall, Stuart - WCP <SHenshall@westcountrypublications.co.uk>
0 siblings, 0 replies; 2+ messages in thread
From: Henshall, Stuart - WCP @ 2002-05-31 08:50 UTC (permalink / raw)
To: Wei Weng <wweng@kencast.com>; pgsql-sql
I believe it pushes any clauses it can into the individual sub-plans, and
anything it can't it leaves above the join.
- Stuart
> -----Original Message-----
> From: Wei Weng [mailto:wweng@kencast.com]
> Sent: 30 May 2002 18:07
> To: pgsql-sql@postgresql.org
> Subject: question on JOIN and WHERE clause
>
>
> Does the SQL optimizer process the JOIN first then add WHERE
> constraintson it or it processes the WHERE clause and JOIN at the same
> time?
>
> Thanks!
>
>
>
> --
> Wei Weng
> Network Software Engineer
> KenCast Inc.
>
>
>
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2002-05-31 08:50 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-05-30 17:07 question on JOIN and WHERE clause Wei Weng <wweng@kencast.com>
2002-05-31 08:50 Re: question on JOIN and WHERE clause Henshall, Stuart - WCP <SHenshall@westcountrypublications.co.uk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox