Re: BITMAP Versus B-TREE

From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Mon, 25 Jun 2007 15:45:01 -0700 (PDT)
Message-ID: <150564.98080.qm@web38904.mail.mud.yahoo.com>

The point that was being made is that bitmap index use, in high DML activity databases, can lead to blocking lock issues that normal BTree indexes do not incur. You have to be really careful in a highly transactional system when you introduce bitmap indexes to the mix.

RF

• Raj Mareddi <yoursraju007_at_gmail.com> wrote:

> Well, These indexes do exist already.
> On 6/25/07, Shamsudeen, Riyaj <RS2273_at_att.com>
> wrote:
> > 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.

Robert G. Freeman
Author:
Now Available for Pre-Sales on Amazon.com!!!!

---

Oracle Database 11g New Features (Oracle Press)

---

Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press) Oracle9i RMAN Backup and Recovery (Oracle Press) Oracle9i New Features (Oracle Press)

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

Received on Mon Jun 25 2007 - 17:45:01 CDT