Re: [PERFORM] Left Join Performance vs Inner Join Performance

2006-01-10 Thread Tom Lane
"Dave Dutcher" <[EMAIL PROTECTED]> writes: > I have an inner join query that runs fast, but I when I change to a left > join the query runs 96 times slower. This looks like an issue that is fixed in the latest set of releases, namely that OUTER JOIN ON conditions that reference only the inner side

[PERFORM] Left Join Performance vs Inner Join Performance

2006-01-10 Thread Dave Dutcher
Hello,   I have an inner join query that runs fast, but I when I change to a left join the query runs 96 times slower.  I wish I could always do an inner join, but there are rare times when there isn’t data in the right hand table.  I could expect a small performance hit, but the differen