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

Home -> Community -> Usenet -> c.d.o.server -> Re: Strange CBO Behaviour with a Bitmap Index

Re: Strange CBO Behaviour with a Bitmap Index

From: <sybrandb_at_yahoo.com>
Date: 1 Feb 2006 04:19:36 -0800
Message-ID: <1138796376.560902.321510@g49g2000cwa.googlegroups.com> 





Your problem is that bitmap indexes are manipulated in blocks, and not
in individual keys.


For every DML operation the full bitmap index needs to manipulated.
Using the bitmap index in a mass DELETE statement doesn't make sense.
In this case upgrading to 10g wouldn't help, it is an architectural
feature of bitmap indexes you are hitting.


-- 
Sybrand Bakker
Senior Oracle DBA


Received on Wed Feb 01 2006 - 06:19:36 CST












Original text of this message













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