Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: BITMAP Versus B-TREE

RE: BITMAP Versus B-TREE

From: Shamsudeen, Riyaj <RS2273_at_att.com>
Date: Mon, 25 Jun 2007 08:34:30 -0500
Message-ID: <6A4102F59ECFA248B81F7D08F0317978014CB530@TBDCEXCH01.US.Cingular.Net>


Raj

        If there is high DML activity on the table, then careful consideration should be given while choosing bitmap index. By design, bitmap indices are not suitable for tables with high DML activity.

        I have created bitmap indices on columns with very few distinct values (10-) and also with high distinct values(Millions+), both improving performance.

        But, you said there is just one distinct value for a column? Why do you want to index that column?

Michael,

>>I find a little "buggier".

What do you mean "buggier"? Do you have specific test case that proves that there are issues with bitmap index? And What version? What administration overhead are you referring to ?

Thanks
Riyaj Shamsudeen

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Michael McMullen Sent: Monday, June 25, 2007 8:16 AM
To: 'oracle-l'
Subject: RE: BITMAP Versus B-TREE

Do you mean the column has only one value, including nulls? I wouldn't put
an index on that.
Yes, bitmaps are great for queries but a pain for loading. They can also really favour certain access paths and I find a little "buggier". They can
also grow like crazy.
I would say, if you heavily use bitmaps, it increases your administration.
Like all things oracle, it's the details that kill you.

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jun 25 2007 - 08:34:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US