Hi,

I can tell you one thing, Instead of Creating Bitmap Index have it Normal.

I have gone through this. The Bitmap is good if you numerous number of Rows with low cardinality, for smaller number of rows, this really does not work.

Try using Exists instead of using In.

AThanks