Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] Good Optimization - Mailing list pgsql-sql

From Patrik Kudo
Subject Re: [SQL] Good Optimization
Date
Msg-id 37845CC3.A2391717@partitur.se
Whole thread Raw
In response to Re: [SQL] Good Optimization  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-sql
Tree view 
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å!

pgsql-sql by date:

Previous
From: wieck@debis.com (Jan Wieck)
Date:
Subject: Re: [SQL] Good Optimization
Next
From: Don Yury
Date:
Subject: outer joins