Re: Bitmap Index
- From: Yechiel Adar <adar76@xxxxxxxxxxxx>
- Date: Tue, 11 Oct 2005 09:30:18 +0200
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
