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: Bitmap Indexes & Table Inserts

Re: Bitmap Indexes & Table Inserts

From: Bob Fazio <rfazio_at_home.com.nospam>
Date: 2000/06/25
Message-ID: <9Fs55.19853$A%3.215179@news1.rdc2.pa.home.com>#1/1

A bitmap index need's to be rebuild after each insert, very painful. Drop and re-create.

--
Robert Fazio, Oracle DBA
rfazio_at_home.com
remove nospam from reply address
http://24.8.218.197/
"stuarti" <stuirvineNOstSPAM_at_hotmail.com.invalid> wrote in message
news:1140a557.08b68ae8_at_usw-ex0105-036.remarq.com...

> Is there a performance hit when using bitmap indexes as oposed
> to b-tree indexes when inserting large amounts of data into a
> table ??
>
>
>
> Got questions? Get answers over the phone at Keen.com.
> Up to 100 minutes free!
> http://www.keen.com
>
Received on Sun Jun 25 2000 - 00:00:00 CDT

Original text of this message

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