Обсуждение: Optimizer question with equivalent joins

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

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