--- In firebird-support@yahoogroups.com, "nikicab_1999"
<nikicab_1999@...> wrote:

>
> Huh, thanks Dmitry. I have switched the code to use
> record_id=ANY(Select...). Which one would be faster in my case, IN or
> (ANY)?

They are equivalent. Internally they both do an EXISTS anyway. Old
versions may perform better with an exists clause but FB 1.5+ (perhaps
even earlier) internally optimise them the same way.

Adam