| From: | "Henshall, Stuart - WCP" <SHenshall(at)westcountrypublications(dot)co(dot)uk> |
|---|---|
| To: | 'Wei Weng' <wweng(at)kencast(dot)com>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: question on JOIN and WHERE clause |
| Date: | 2002-05-31 08:50:23 |
| Message-ID: | E2870D8CE1CCD311BAF50008C71EDE8E01F748CA@MAIL_EXCHANGE |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)kencast(dot)com]
> Sent: 30 May 2002 18:07
> To: pgsql-sql(at)postgresql(dot)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.
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oleg Bartunov | 2002-05-31 11:10:05 | Re: contrib/intarray |
| Previous Message | Achilleus Mantzios | 2002-05-31 08:18:00 | contrib/intarray |