Re: Bitmap Join Index

Thanks Anurag, thats an excellent article! It cleared many of my misconceptions already.

I was able to create the BJI and use it successfully. However, the optimizer seem to use the BJI only when I force it with a hint. If I don't use a hint, it goes for a full table scan and runs a lot slower.

Any idea why the BJI is not picked up by the optimizer? If necessary, I can post the sql & explain plan. Let me know. Received on Mon Feb 12 2007 - 09:05:55 CST