Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Bitmapped Indexes, Anyone?
Steve Phelan wrote:
>
> Look in Oracle 7.3 Server Tuning, starting page 7-34.
>
> Stephen Turner wrote:
>
> > I've read in several press releases, magazine articles and books
> > about a mystical new feature of Oracle 7.3, the bitmapped index.
> > I even saw a description of how to create one of these elusive
> > creatures <CREATE BITMAP INDEX BM_IDX ON TAB_NAME (COLUMN); >
> >
> > However, none of our 7.3 documentation seems to refer to these
> > objects and I can't issue the above statement in SQL*Plus.
> >
> > Has anyone out there created such indexes with 7.3 & if so how?
> > Is there a server option which is needed?
> >
> > We are running Oracle 7.3.2.
> >
> > Thanks,
> > Steve Turner.
I haven't used Bitmapped indexes myself yet. Pete Cassidy of Database
Consultants, Inc. gave a presention "Performance Comparisons Using
Bitmap Indexes, Hash Clusters, and Histograms" at IOUW in Dallas
recently. His paper is #23 in the conference proceedings.