Re: Bitmap Index

Just check it.
Build an index an rerun the queries and compare time.

Adar Yechiel
Rechovot, Israel

DBA Deepak wrote:

> Hi All,
>
> In my DWH DB I have a table with few million rows. I have a column in
> the table having 15 distinct values. That column is being used in the
> where clause of the queries. What I am interested to know is would it
> be beneficial to create a bitmap index on it.
>
> Is there any specific ratio (distincy values)/(Num of rows) at which
> one must consider creating bitmap indexes rather than b-tree indexes?
>
>
>
> --
> Regards,
>
> Deepak
> Oracle DBA

--
http://www.freelists.org/webpage/oracle-l