if your query performance drop when use IN in sql query command .
try to use EXISTS instead of IN for better query performance
for example
Use this code for best performance
select * from my_table where
exists (select 1 from dual where my_field in (1,2,3,4,5,6,7,8,9,10) )
instead of
select * from my_table where
my_field in (1,2,3,4,5,6,7,8,9,10)