Query Performance

[Guest]

Given 2 large tables and joining them on a common key field, would the query
performance (run-time) be better, worse, or no difference using a left outer
join compared to an inner join.

I had someone tell me a left outer join would run the query faster than an
inner join. I say there is no difference in query time. Any thoughts?

 

[Rick B]

Why don't you try running it both ways and see which one takes longer?
Seems like that would be faster than waiting for one of us to experiment
with it and report back.