Re: Bitmap Idx

From: John Morais <jmorais_at_rochester.rr.com>
Date: Thu, 14 Jun 2001 13:10:00 GMT
Message-ID: <II2W6.27474$3y3.4364794@typhoon.nyroc.rr.com>

If your are running CBO first thing is analyze the table.

"Sunder" <sunder.nochilur_at_us.bosch.com> wrote in message news:3B28B11D.AD6B2A6_at_us.bosch.com...
> I have a table called TABLEA with columns COL1, COL2, COL3, COL4
> I have created Bitmap indexes on COL1 and COL2.
>
> When I do a explain plan on
>
> select count(!) from TABLEA where COL1 = 'A';
>
> The indexes are not used.
>
> If i do an explain plan on
>
> select /*+ INDEX(TABLEA,COL1_IDX) */
> count(1) from TABLEA where COL1 = 'A';
>
> The index is used.
>
> My question : how do I get the bitmap index to be used by default.
> (without using the hint ).
>
> Thanks
> Sunder
>
Received on Thu Jun 14 2001 - 08:10:00 CDT