Postgres Pro
Downloads
Home   >   mailing lists

Re: joins and indexes -- a=b or b=a? - Mailing list pgsql-general

From Tom Lane
Subject Re: joins and indexes -- a=b or b=a?
Date
Msg-id 20340.985821955@sss.pgh.pa.us
Whole thread Raw
In response to joins and indexes -- a=b or b=a?  (will trillich <will@serensoft.com>)
List pgsql-general
Tree view 
will trillich <will@serensoft.com> writes:
> the only difference is GANG.ID=PERSON.GANG versus
> PERSON.GANG=GANG.ID in the WHERE clause. does it matter?

No.  The query planner knows about commutativity ;-)

            regards, tom lane

pgsql-general by date:

Previous
From: will trillich
Date:
Subject: explain shows lots-o-preliminary sorting
Next
From: Tom Lane
Date:
Subject: Re: optimizing a view-driven query