[GENERAL] Query optimization question - Mailing list pgsql-general

From Ed Loehr
Subject [GENERAL] Query optimization question
Date
Msg-id 385DDFE9.8BB91CB7@austin.rr.com
Whole thread Raw
List pgsql-general
Which is faster?  This...

    SELECT t1.name
    FROM t1, t2, t3, t4
    WHERE
        t1.id = 1 AND
        t2.id = 2 AND
        t3.id = 3 AND
        t3.id = t4.id;

...or this...


    SELECT t1.name
    FROM t1, t2, t3, t4
    WHERE
        t1.id = 1 AND
        t3.id = t4.id AND
        t2.id = 2 AND
        t3.id = 3;

Does it make a difference in pgsql?

Cheers,
Ed Loehr


pgsql-general by date:

Previous
From: "omid omoomi"
Date:
Subject: Re: [GENERAL] dynamic queries in Postgres
Next
From: "Justin Hickey"
Date:
Subject: Re: [GENERAL] Confirmation of feature of in version 7