Re: Bitmap Index

From: Shivanischal A <shivan_at_subexsystems.com>
Date: Mon, 10 Oct 2005 15:46:46 +0530
Message-Id: <1128939406.23414.1.camel@linux1.subex>

Hi Deepak,

Just wondering... How about "List Partitioning" if you know each of the 'distinct' values before hand?

Regards,
Shiva

On Mon, 2005-10-10 at 15:45, 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

Received on Mon Oct 10 2005 - 05:26:51 CDT