Re: SQL - long list in the where clause. Any ideas?

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Tue, 04 Feb 2003 08:19:22 -0800
Message-ID: <3E3FE80A.C47968EE@exesolutions.com>

Dale Edgar wrote:

> On 31 Jan 2003 13:06:59 -0600, anon_at_anon.com (dev) wrote:
>
> >I now have a requirement that may cause this list to be huge. Oracle
> >has a limitation of 2000 items in an IN statement. I have tried using
> >many OR statements but perfomrance is terrible.
>
> Just as an aside, the number is actually considerably less (approx
> 256) on early versions of Oracle 8 and all of Oracle 7.
>
> -Dale
> -------------
> DataBee: Create referentially correct small versions of large Oracle
> databases for development and test. http://www.DataBee.com

Well yes and no. Consider a bit of creativity such as UNION ALL. Or a mixture of BETWEEN and IN.

Daniel Morgan Received on Tue Feb 04 2003 - 10:19:22 CST