Using Bimap Indexes in V7.3?

We are a data warehouse applications group with over 20 Gbytes of data.

Because our users do ad-hoc queries, we are using single column indexes to take advantage of the AND-ALL function of the optimizer.

We would like to use bitmap indexes, but so far have had mixed results. Some tables will not allow them to be built, failing with an internal error [20080]. We put them on those that would run to completion, and ended up with 3 of the six tables in the partition view using Bitmaps and the other 3 using standard indexes, which Oracle says in valid, supposedly you can even mix bimap and standard on the same table.

We had to back the Bitmap indexes out and revert to all standard when the CPU usage on our HP-UX 10.01 server went through the roof, with no I/O going on.

Anyone else out there trying this option. Reply here or directly to me at Paul_D_Phillips_at_ccmail.orl.lmco.com

TIA. Received on Fri Feb 21 1997 - 00:00:00 CST