Dirk Lutzebaeck <[EMAIL PROTECTED]> 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
---
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 w
