On Wed, Jul 1, 2009 at 11:37 AM, Rui Carvalho<rui.hmcarvalho@xxxxxxxxx> wrote: > hum thanks a lot for the quick answer, > > if is not abuse of your patience > > what is the best alternative to the LEFT OUTER JOINS? Hard to say. Generally, when you really do need a left, right, or full outer join, you need it, and there's not a lot of alternatives. Sometimes putting a where clause portion into the on clause helps. like: select * from a left join b on (a.id=b.id) where a.somefield=2 might run faster with select * from a left join b on (a.id=bid. and a.somefield=2); but it's hard to say. I'd definitely post it to the list and see who knows what. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
