Re: Large IN LIST in an OBIEE query

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.

http://rafudb.blogspot.com/2011/10/variable-inlist.html

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

--
Timo Raitalaakso
http://rafudb.blogspot.com


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

--
http://www.freelists.org/webpage/oracle-l