Postgres Pro
Downloads
Home   >   mailing lists

Re: Optimizer question with equivalent joins - Mailing list pgsql-sql

From Tom Lane
Subject Re: Optimizer question with equivalent joins
Date
Msg-id 19933.1024672716@sss.pgh.pa.us
Whole thread Raw
In response to Optimizer question with equivalent joins  (Dirk Lutzebaeck <lutzeb@aeccom.com>)
List pgsql-sql
Tree view 
Dirk Lutzebaeck <lutzeb@aeccom.com> writes:
> say I have a join which says
>     t.a = t.b and t.b = t.c
> do I need to give the optimizer a hint by saying it more redundantly
>     t.a = t.b and t.b = t.c and t.c = t.a

Not since about 7.0.3 ...
        regards, tom lane

pgsql-sql by date:

Previous
From: Dirk Lutzebaeck
Date:
Subject: Optimizer question with equivalent joins
Next
From: Cliff Wells
Date:
Subject: Re: [ADMIN] Incredible..