Re: Bitmap Join Index

From: Anurag Varma <avoracle_at_gmail.com>
Date: 12 Feb 2007 10:56:40 -0800
Message-ID: <1171306600.421359.156370@j27g2000cwj.googlegroups.com>

On Feb 12, 10:08 am, "aravind.ka..._at_gmail.com" <aravind.ka..._at_gmail.com> wrote:
> 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.

Go ahead and post the sql & explain plan. Before you do so, make sure you have gathered statistics on the table and index (dbms_stats...)
and please state your oracle version.

Anurag Received on Mon Feb 12 2007 - 12:56:40 CST