Bitmap Index
- From: DBA Deepak <oracle.tutorials@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 10 Oct 2005 15:45:51 +0530
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
Other related posts:
