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: Michael McMullen <ganstadba_at_hotmail.com>
Date: Mon, 25 Jun 2007 09:16:01 -0400
Message-ID: <BAY141-DAV5954AE86F56B52B767257A6140@phx.gbl>
Message-ID: <002c01c7b72a$f9eae9e0$cb7810ac@bell.corp.bce.ca>


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
Received on Mon Jun 25 2007 - 08:16:01 CDT

Original text of this message

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