Ethan,
Our data warehouse has both bit map and b-tree indexes and we normally do
not have a problem. One headache we do have is that one of the indexes is on a
column that accumulates a lot on new values each time the warehouse is loaded
which really makes a mess of the load process, namely
Darren,
I would not say it's a problem with bit map indexes, although they have
other problems, but indexes in general especially when those indexes are
involved in a lot of insert, delete, and update activity. What appears to
happen, and although I've a lot of evidence to support the