Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP id 659E047720A
	for <pgsql-sql@postgresql.org>; Fri, 21 Jun 2002 10:31:49 -0400 (EDT)
Received: from k3.core.aeccom.com (gate2.aeccom.com [195.211.178.194])
	by postgresql.org (Postfix) with ESMTP id 8A69447701A
	for <pgsql-sql@postgresql.org>; Fri, 21 Jun 2002 10:26:09 -0400 (EDT)
Received: from cayambe.core.aeccom.com (cayambe.core.aeccom.com
 [192.168.2.12])
	by k3.core.aeccom.com (8.11.6/8.11.6) with ESMTP id g5LEQ3K07747;
	Fri, 21 Jun 2002 16:26:03 +0200
Received: (from lutzeb@localhost)
	by cayambe.core.aeccom.com (8.11.2/8.11.0) id g5LEQ3427239;
	Fri, 21 Jun 2002 16:26:03 +0200
From: Dirk Lutzebaeck <lutzeb@aeccom.com>
MIME-Version: 1.0
Message-ID: <15635.14203.405079.671597@cayambe.core.aeccom.com>
Date: Fri, 21 Jun 2002 16:26:03 +0200
To: pgsql-sql@postgresql.org
Subject: Optimizer question with equivalent joins
X-Mailer: VM 6.89 under 21.1 (patch 14) "Cuyahoga Valley" XEmacs Lucid
User-Agent: SEMI/1.13.7 (Awazu) CLIME/1.13.6 (=?ISO-2022-JP?B?GyRCQ2YbKEI=?=
	=?ISO-2022-JP?B?GyRCJU4+MRsoQg==?=) MULE XEmacs/21.1 (patch 14)
	(Cuyahoga Valley) (i386-redhat-linux)
Content-Type: text/plain; charset=US-ASCII
X-Archive-Number: 200206/293
X-Sequence-Number: 8258


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