Re: [SQL] Good Optimization

From: Patrik Kudo <kudo(at)partitur(dot)se>
To: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] Good Optimization
Date: 1999-07-08 08:09:39
Message-ID: 37845CC3.A2391717@partitur.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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å!

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Eric BASIER 1999-07-08 08:27:43 concatenation varchar and float
Previous Message Bruce Momjian 1999-07-08 03:04:00 Re: [SQL] Index on Type Numeric