Re: Experience in bitmap index in Oracle 7.3

[Quoted] I can't find this documented anywhere.

Is it only supported on Sun?

I'm running on Dec Alpha, and can find a dicky bird on 'Binary Indexes'.

Some help please.

Curiously

Justin Crooks

Ray Stafford wrote:
>
> Bitmap indexes are a good performance booster when you are dealing with
> highly repetative data. On Sun Solaris you must have oracle release
> 7.3.2.3 and set
> compatabiltiy = 7.3.2.
>

.. blah blah ..

e used in a parallel query. During our conversion to bitmap indexes we
> had a reduction in index size on 1 field from 438 megs to 700k. The table
> contains 12 million rows of data and field was on the state abbreviation
> char(2). The query time to count records where state = 'NY'
> went from 1.38 seconds to .02 seconds.
>
> In total we have reduced our total index storage requirements by 70% and
> increased the performance of the system by 62%. If have specific questions
> you can e-mail me directly.
> --
> Ray Stafford
> rstaffor_at_lcp.com
>
  Received on Fri Feb 07 1997 - 00:00:00 CET