"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
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