From: haroldPer@hotmail.com (Harold Pearson)
Newsgroups: comp.databases.oracle.server
Subject: any reasons why updating a bitmap clolumn would be 20-50x slower then with out it
Date: 12 Dec 2000 16:31:19 -0600
Lines: 9
Message-ID: <3a36a687$0$92409$45beb828@newscene.com>
X-Newsreader: News Xpress 2.01


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