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

From: Dale Edgar <Dale_at_DataBee.com>
Date: Tue, 4 Feb 2003 08:20:22 +0000 (UTC)
Message-ID: <3e3f7791.320679192@news.btclick.com>

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 Received on Tue Feb 04 2003 - 02:20:22 CST