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_at_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.

DataBee: Create referentially correct small versions of large Oracle databases for development and test. http://www.DataBee.com Received on Tue Feb 04 2003 - 09:20:22 CET

This message: [ Message body ]
Next message: Vasileios Lourdas: "Re: Oracle 8.1.7 install on RedHat 8.0"
Previous message: dfinger: "Re: Oracle 8.1.7 install on RedHat 8.0"
Maybe in reply to: Vattekkat Satheesh Babu: "Re: SQL - long list in the where clause. Any ideas?"
Next in thread: DA Morgan: "Re: SQL - long list in the where clause. Any ideas?"
Reply: DA Morgan: "Re: SQL - long list in the where clause. Any ideas?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message