Optimizer question with equivalent joins - Mailing list pgsql-sql

From Dirk Lutzebaeck
Subject Optimizer question with equivalent joins
Date
Msg-id 15635.14203.405079.671597@cayambe.core.aeccom.com
Whole thread Raw
Responses Re: Optimizer question with equivalent joins  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Hello,

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

or is this just counter productive because there is one more join?

In the real world I have 10-20 equivalent joins which would really
blow up if I have to choose the second option.

Dirk




pgsql-sql by date:

Previous
From: Jan Wieck
Date:
Subject: Re: how to sort a birthday list ?
Next
From: Tom Lane
Date:
Subject: Re: Optimizer question with equivalent joins