Re: Bitmap Index
- From: Shivanischal A <shivan@xxxxxxxxxxxxxxxx>
- To: oracle.tutorials@xxxxxxxxx
- Date: Mon, 10 Oct 2005 15:46:46 +0530
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
