Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Bitmap indexes
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