Subject | Re: [ib-support] select etc. |
---|---|
Author | Svein Erling Tysvaer |
Post date | 2003-03-18T12:20:14Z |
That's great news Arno! When did this change happen?
Set
At 12:38 18.03.2003 +0100, you wrote:
Set
At 12:38 18.03.2003 +0100, you wrote:
>Internally the IN is converted to an sub-query which will look like this :
>
>SELECT MYFIELD1 FROM MYTABLE2 WHERE MYTABLE2.MYFIELD1 = MYTABLE1.MYFIELD1
>
>So i don't expect any difference in speed here between IN and EXISTS.