question on JOIN and WHERE clause

From: Wei Weng <wweng(at)kencast(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: question on JOIN and WHERE clause
Date: 2002-05-30 17:07:21
Message-ID: 1022778442.32670.1.camel@Monet
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-sql by date

  From Date Subject
Next Message Wei Weng 2002-05-30 17:11:22 Re: Can you help with this JOIN?
Previous Message Oleg Bartunov 2002-05-29 20:06:28 Re: contrib/tree issues