Subject Re: inner join with additional conditions
Author Svein Erling Tysvær
Hi Adam!

> Now I have told you to always do it one way, there may be a few
> performance hacks where you may have to break this rule to get a
> decent plan. By moving an expression between the join condition and
> where clause in a complex query, it may assist the optimiser. But this
> is the exception rather than the rule, and I have never seen it on
> such a simple query.

This makes me curious. I cannot remember to have seen such a case, but expect this to be due to me still being on Fb 1.5. In what kind of situations have you observed such behaviour?