This message was deleted.

I know of use cases using thousands of values for IN clause. Not sure if it has a limit. Have you tested it?

I did test till 5K worked fine to me, but was trying to understand the impact of it if the list is huge. I am assuming the slowness of bitmap will have some impact ? Not sure though.