Received: from bastuba.partitur.se (bastuba.partitur.se [193.219.246.194]) by hub.org (8.9.3/8.9.3) with ESMTP id EAA30481 for ; Thu, 8 Jul 1999 04:10:34 -0400 (EDT) (envelope-from kudo@partitur.se) Received: from partitur.se (tb303.partitur.se [193.219.246.230]) by bastuba.partitur.se (8.8.8/8.8.8) with ESMTP id KAA17327; Thu, 8 Jul 1999 10:09:39 +0200 (CEST) (envelope-from kudo@partitur.se) Sender: kudo@partitur.se Message-ID: <37845CC3.A2391717@partitur.se> Date: Thu, 08 Jul 1999 10:09:39 +0200 From: Patrik Kudo Organization: Partitur Informationsteknik X-Mailer: Mozilla 4.51 [en] (X11; I; FreeBSD 3.2-STABLE i386) X-Accept-Language: sv,en MIME-Version: 1.0 To: Bruce Momjian CC: pgsql-sql@postgresql.org Subject: Re: [SQL] Good Optimization References: <199907071801.OAA05018@candle.pha.pa.us> Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Bruce Momjian wrote: > > Added to TODO: > > * In WHERE x=3 AND x=y, add y=3 I don't know if I'm way off, but wouldn't removing "x=y" improve performance further? -- ech`echo xiun|tr nu oc|sed 'sx\([sx]\)\([xoi]\)xo un\2\1 is xg'`ol Känns det oklart? Fråga på!