Re: Bitmap Index, when use it?

From: <>
Date: Mon, 28 Jan 2008 10:32:43 -0800 (PST)
Message-ID: <>

On Jan 28, 7:50 am, Cassiano <> 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

Original text of this message