Yes, I have experienced same issues what slimdave mentioned in our data warehosuing environment(8173). Either way it sucks for maintenance issues. B-Tree indexes to be created takes forever and bit map indexs have to be dropped and recreated each and every time you do massive data operations (DML).

Bit-map indexes goes thru compression and expansion algoritm for heavy DML which is big overhead and cause performance issues.

As Slimdave suggested proper testing needed specific to kinda activity on the database in your shop.