Subject Re: SQL query question (IN limitation)
Author Adam
--- In, "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.