Bitmap Index, when use it?

From: Cassiano <>
Date: Mon, 28 Jan 2008 05:50:31 -0800 (PST)
Message-ID: <>


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.

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?

Thanks for help.

Cassiano Roloff
DBA Oracle - Porto Alegre/RS/Brazil Received on Mon Jan 28 2008 - 07:50:31 CST

Original text of this message