>>It would help if you posted the query and the execution plan to figure out what is going on.
>
>It was general on a few queries I observed this on.

If you mean the difference between an INNER JOIN and a LEFT JOIN, i guess in alot of cases there will not be any difference in the execution plan because the operation to execute both are very similar.