Re: GROUP BY

someuser_at_some.host (Some One ) wrote:
>
>Martin Smith wrote:
>>
>> Using a bit-mapped index on the WHERE variable(s) can make a HUGE
>> difference, assuming you're actually cutting down the selected rows
>> significantly.
>>
>> Actually, Oracle should in principle be able to do the count using J
 UST
>> the bit-mapped index itself--it has the info. Wonder if that's
>> implemented??
>>
>> mfs
>
>What do you mean by bit-mapped index?
> ^^^^^^^^^^^^^^^^
>Thanks..
>

[snip]
A new feature of Oracle as of late(NT 7.3.3) Try

Create bitmap index test on rep ( status );

-- 
                      \\///
                      (0-0)
           +----oOO----(_)-----------+
           |       K. E. Fein        |
           |    Database Analyst     |
           |   kfein_at_primenet.com    |
           +------------------oOO----+