Thread: [GENERAL] Query optimization question

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