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.
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
