Re: BIT MAP INDEXES......

From: Bjørn Pedersen <bjoped_at_online.no>
Date: 1997/10/20
Message-ID: <344BD174.30B856DD@online.no>#1/1

The syntax is quite simple:

CREATE BITMAP INDEX my_index on ...

Bitmap indexes should as a rule be used on colums that have relatively few distinct values.
But some say they can be used effectively on data where up to 50-75% of the total consists of different values. It all depends how the indexes are used in queries. You should get a good book on the subject.

Alistair Thomson wrote:

> Can anyone point me in the right direction for setting up a bit map
> index?
>
> Are parameters required in the init.ora file? What syntax do you use to
> create the index?
>
> I don't have manuals other than the online help and thats not much use!
>
> Please email response to alit_at_levelv.co.uk
>
> Thanks for any help.
>
> Alistair Thomson
Received on Mon Oct 20 1997 - 00:00:00 CDT