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 -> any reasons why updating a bitmap clolumn would be 20-50x slower then with out it

any reasons why updating a bitmap clolumn would be 20-50x slower then with out it

From: Harold Pearson <haroldPer_at_hotmail.com>
Date: 12 Dec 2000 16:31:19 -0600
Message-ID: <3a36a687$0$92409$45beb828@newscene.com> 






we have 90 million row table with cloumn with 50 different values
we create index and did analyze with histogram



we then loaded rows got 7 rows per sec update speed
before we created bitmap it was 400 rows per sec for updating speed



any reason why such difference



we took off bitmap and it went back to 400 rows per sec
Received on Tue Dec 12 2000 - 16:31:19 CST












Original text of this message













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