Re: Bitmap Index, when use it?

On Jan 28, 7:50 am, Cassiano <cassianorol..._at_gmail.com> wrote:
> Hello,
>
> I've a table wich 6 milions of rows, and this table have one column
> "TYPE" char(2).
> This column is used to descript the type of the row.

I'll presume this table has more than one column, but this TYPE column (not a good naming choice, by the way) is your column of interest.

>
> This column have 35 distict values and is frequently used in "where"
> clause.
>
> I think this is a good column to create an Bitmap index? It's true? or
> 35 distict values is so much to bitmap indexes?

I would think that it is a good candidate for a bitmap index.

>
> Thanks for help.
>
> Cassiano Roloff
> DBA Oracle - Porto Alegre/RS/Brazil

David Fitzjarrell Received on Mon Jan 28 2008 - 12:32:43 CST