Re: BITMAP Versus B-TREE
- From: Robert Freeman <robertgfreeman@xxxxxxxxx>
- To: yoursraju007@xxxxxxxxx, RS2273@xxxxxxx
- Date: Mon, 25 Jun 2007 15:45:01 -0700 (PDT)
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@xxxxxxxxx> wrote:
> Well, These indexes do exist already.
> On 6/25/07, Shamsudeen, Riyaj <RS2273@xxxxxxx>
> 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)
--
//www.freelists.org/webpage/oracle-l
Other related posts:
