| Subject | Re: [ib-support] Re: sql - diference in join tables |
|---|---|
| Author | Svein Erling Tysvaer |
| Post date | 2003-03-06T14:18:46Z |
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.
Set
At 13:41 06.03.2003 +0000, you wrote:
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.
Set
At 13:41 06.03.2003 +0000, you wrote:
>Is there any difference in the performance?