| Subject | Odp: [firebird-support] Computed index |
|---|---|
| Author | liviuslivius@poczta.onet.pl |
| Post date | 2013-10-10T05:08:47Z |
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
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" <kdv@...>
Do: <firebird-support@yahoogroups.com>
Temat: Odp: [firebird-support] Computed index
Data: śr., paź 9, 2013 17:57
Od: "Dmitry Kuzmenko" <kdv@...>
Do: <firebird-support@yahoogroups.com>
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