From: Oliver Critchley <oliver.critchley@no.spam.please>
Subject: Re: Anyone use bitmap indexes?
Date: 1997/12/12
Message-ID: <349175FC.6226@no.spam.please>#1/1
Content-Transfer-Encoding: 7bit
References: <348EB6D9.13203A46@dpl.leeds.ac.uk>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Organization: AIT
Newsgroups: comp.databases.oracle



Tim Palmer wrote:
> 
> Hi,
> 
> Does anybody out there know anything about bitmap indexing. From what i
> know of them they sound perfect for
> many of the tables in our system. On a recent course i was told they
> would work with oracle server 7.3.3 onwards, we use 7.3.2 - but ive also
> been told that they will work here as well. The fact that im sending
> this note means they dont! Or at least when i try the  'create
> index....etc' syntax with bitmap clause.
> 
> In a nutshell, does anybody know what version of oracle (and if
> applicable server configuration) is needed to get these things to work.
> 
> Thanks in anticipation
> 
> Tim Palmer

Although I've never tried bitmap indexes myself, I believe that they work with Oracle 7.3.* onwards. 
Furthermore, apparently they only work with the Enterprise edition of the server and not with the 
Workgroup edition (although the documentation makes no mention of this fact).

Good luck!

Oliver