| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: bitmap index Q.
Is it true that if data is loaded in *sequential* order, with indexing on,
the index gets lop sided. Thus only rebuilding the index(es) can
restore its beneficial, shallow and wide structure.
Unless there is automatic tree-balancing for indexes that Oracle does by itself?
Akshay Jain
-----Original Message-----
From: Lisa_Koivu_at_gelco.com [mailto:Lisa_Koivu_at_gelco.com]
Sent: Friday, April 28, 2000 3:54 PM
To: Multiple recipients of list ORACLE-L
Subject: bitmap index Q.
Hola!
One of our data marts here had awful performance yesterday. The only thing
that
was different between yesterday and the previous days was that the load ran
with
all indexes, including bitmaps, on the tables. Only 10,000 rows were added
-
less than 1% change. The analyze was run for all tables to be hit by the
reports. However performance really bit yesterday until the indexes were
dropped and rebuilt.
In class I remember talking about the tradeoff between a fast load/building indexes and a slow load/leaving indexes up. Has anyone seen this type of behavior before? I can not say for sure that the load is not updating the fields the bitmap indexes were on.
Any comments are appreciated.
Lisa 'Almost Certified' Koivu
-- Author: INET: Lisa_Koivu_at_gelco.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Fri Apr 28 2000 - 16:34:54 CDT
 |
 |