Hint to get this Query plan?

I have a table with two columns a,b both of which have bitmap indexes on them. I want counts grouped by both columns, is there any way to do a bitmap conversion to counts?

ie,

select count(*),a,b from tbl group by a,b;

does a full table scan right now, but

select count(*),a from tbl group by a;
and
select count(*),b from tbl group by b;

both do a bitmap conversion. Is there any way to get oracle to do some kind of combine on the two indexes to get the counts?

--
greg Received on Tue Feb 08 2000 - 12:11:02 CST