Re: Bitmap Join Index

Thanks Anurag. That was an excellent article! It cleared many of my misconceptions already.

I created an BJI and the optimizer seem to pick up the index only when I force with a hint. It is because that optimizer thinks that a full table scan is lot cheaper than using that index??

Any clues?? I can post the sql & explain plan if necessary. Thanks. Received on Mon Feb 12 2007 - 09:08:03 CST