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 cause slow load

Re: Bitmap indexes cause slow load

From: Peter C. Hugger <phugger_at_home.com>
Date: Fri, 11 May 2001 08:42:30 -0400
Message-ID: <tfnnml3e2e7v44@corp.supernews.com> 






We have seen problems similar to this using bitmap indexes. Have you checked
the sizes of your indexes after a load? Of far greater concern to us was the
huge increase in size after performing inserts - talking orders of magnitude
here. This *bug* has been reported and fairly well documented. Our solution
is to perform periodic rebuilds (our table is partitioned).



PCH

Received on Fri May 11 2001 - 07:42:30 CDT












Original text of this message













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