Re: Bitmapped Indexes, Anyone?

To use bitmap indexes you need to install the parallel query option. This cannot be added to an existing install - you have to re-install the whole lot which can be a real pain if you are using 7.3.2.2/3 (because they are patch releases) so it's a case of install the base release (with PQO) then apply the patch.

It may seem like a lot of trouble but it's well worth the effort. Bitmap indexes open up a whole new area of design and functionality for MIS applications - and you'll benefit from parallel query as well!

Let me know how you get on using them.

Good luck.
AJ.

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.
  Received on Thu Jun 12 1997 - 00:00:00 CDT