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 Received on Fri Apr 28 2000 - 13:30:28 CDT