Subject Re: [ib-support] Re: sql - diference in join tables
Author Svein Erling Tysvaer
No, I don't think so if you mean performance difference between JOIN ... ON
ID1 = ID2 and WHERE ID1 = ID2. The only difference I know of is what I said
about JoinLinks in IBO, but there may be other differences as well (I only
know a fraction of IBO, and nothing about IBX, FIB+ etc.). There is of
course a difference when you talk about LEFT/RIGHT/FULL JOIN, but that is
because they are different queries likely to have different output.


At 13:41 06.03.2003 +0000, you wrote:
>Is there any difference in the performance?