Re: I would like to know about IN operator,
From: Pasi Parkkonen <pasi_at_eigenvalue.com>
Date: Wed, 20 Feb 2002 13:45:00 +0200
Message-ID: <a50279$3tn$1_at_tron.sci.fi>
Date: Wed, 20 Feb 2002 13:45:00 +0200
Message-ID: <a50279$3tn$1_at_tron.sci.fi>
"Leader" <sohelcsc_at_yahoo.com> wrote in message
news:b1a93c73.0202190606.7a18c234_at_posting.google.com...
> Hi All,
> I have a problem for that i need to know Is there any maximum range
> within IN operator? I mean inside IN how many values we can compare
> (13, 14, 23,......)??
>
You can use IN operator only with less than 10000 comparisons. For example you cannot use it in sub-select if the sub-select returns more than 10000 rows.
'IN' is also quite slow, you should be able to find another solution.
Regards,
Pasi Parkkonen,
EigenDBA
Received on Wed Feb 20 2002 - 12:45:00 CET