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