Re: Hint to get this Query plan?

Given the normal size and speed of
creation of bitmaps - if this query is
important you could try creating a
bitmap on (a,b).

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Greg Stark wrote in message
<87ln4vwonj.fsf_at_HSE-Montreal-ppp33976.qc.sympatico.ca>...
>
>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 - 13:10:19 CST