Re: Large IN LIST in an OBIEE query

  • From: Timo Raitalaakso <rafu@xxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 31 Oct 2011 16:36:25 +0200

Ain't OBIEE a Java software? I have not touched OBIEE but this could be 
worth checking. I wrote just an blog post about varying inlist.

There I describe using table of SQL type and Java ArrayDescriptor to 
pass huge in lists to database without a temporary table.

Timo Raitalaakso

On 28.10.2011 11:50, Chitale, Hemant Krishnarao wrote:
> I have a few OBIEE queries that "perform poorly".  Apparently, the users
> My questions :
> a.     Have you come across performance issues with very large IN
> LISTS  (1000 entries)
> Hemant K Chitale

Other related posts: