Re: Bitmap Index

Dear Elaine,

The following statement builds a bitmap index for the GENDER column of the CUSTOMERS table, using parallel processing. The index is also built without logging, to further increase the performance of the index build:

CREATE BITMAP INDEX cust_gender
 ON customers (gender)
 PARALLEL (DEGREE 3)
 NOLOGGING; Sincerely,

Arthur Kolkman / Sequel Solutions

E. Nunns wrote:

> Anyone know anything about creating a bitmap index?
>
> I issue the following command in sqlplus:-
>
> create bitmap index xx_bitmap on on xx_table(id);
>
> The following error is display :-
>
> ORA-00901: invalid CREATE command
>
> The version of ORACLE I am using is 7.3 running under openVMS 7.1
> I understood that bitmap indexes were available from 7.3 onwards?
>
> Any suggestions anyone?
>
> Thanks
>
> Elaine
Received on Sun Mar 21 1999 - 15:47:36 CET