Martijn Tonies wrote:

>> What is your opinion about these?
>>
>> I hope I made myself understood
>
> Use whatever is the -logical- thing to do.
>
> If you don't NEED to do a LEFT join, why do one?
>
> Do you understand the functional differences between
> a JOIN and a LEFT JOIN?

Martijn, o' guru one... :)

I do know (I actually do, or at least I think I do) the differences
between JOIN, LEFT JOIN, FULL JOIN.
Probably my posts got into the wrong thread.
I just wanted to get an idea of performance related to the queries I
showed. From the business logic point of view, I knew that those queries
will return the same result. I was curious how the optimizer works in
these two situations and why the fetch time is bigger.
I honestly didn't want to bobble around asking noob questions about how
JOIN works, so I apologize if this was the impression I let

TIA
Radu