Subject RE: [firebird-support] in vs exist
Author Helen Borrie
At 01:00 PM 19/12/2003 +1100, you wrote:
> > Hi,
> >
> > At December 18, 2003, 20:41, Alan McDonald wrote:
>I'm the other way (use IN) but I do only use it when I know that the result
>of the IN subselect is small. It does not perform well when it is large.

Wisely. IN() can handle a maximum of 1500 values and then it excepts. For
IN(subquery) predicates, be safe and use EXISTS() and also save some
processing cycles.