Bitmap Index

From: DBA Deepak <oracle.tutorials_at_gmail.com>
Date: Mon, 10 Oct 2005 15:45:51 +0530
Message-ID: <75aa80160510100315v484b45b6oef7346cd7feb9dda@mail.gmail.com>

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:17:53 CDT