Hi,

It is equivalent for us but i do not remember if the same is for engine in all 
versions.

I never use in operator always "or" or "exists"

Regards,
Karol Bieniaszewski

----- Reply message -----
Od: "Dmitry Kuzmenko" <[email protected]>
Do: <[email protected]>
Temat: Odp: [firebird-support] Computed index
Data: śr., paź 9, 2013 17:57
Hello, liviuslivius!



Wednesday, October 9, 2013, 4:35:50 PM, you wrote:



lpop> First try using "or" not "in" in your query



hmm, what do you mean?



where field in (1,2)



is totally equivalent to



where (field = 1) or (field = 2)



so, "or" or "in" is not different here.



-- 

Dmitry Kuzmenko, www.ib-aid.com









Reply via email to