Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Bitmap indexes

Bitmap indexes

From: Lisa M. Lewis <lmg_at_isdsa.pgh.wec.com>
Date: 1997/06/24
Message-ID: <33B02460.C5809E64@isdsa.pgh.wec.com>#1/1

I would like to use bitmap indexes so I tried:

create bitmap index users_userknown on users(userknown);

I got an error:
ORA-00901: invalid CREATE command.

I read in a book that I have that in Oracle 7.3.2 to enable bitmap indexes you have to add the following to your init.ora file:

event = '10111 trace name context forever'
event = '10112 trace name context forever'
event = '10114 trace name context forever'

Does anyone know if this also applies to 7.3.3? Any tips on using bitmap indexes ( except for the obvious - only use on low cardinality fields ).

Thanks!

Lisa Received on Tue Jun 24 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US