Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Bitmap indexes
On Tue, 24 Jun 1997 15:47:45 -0400, "Lisa M. Lewis" <lmg_at_isdsa.pgh.wec.com> wrote:
>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 ).
>
Bitmap indexes are production in release 7.3.2.3, and do require the parallel query option. You should be able to create bitmap indexes without any special init.ora events (other than an appropriate COMPATIBILITY setting) with this release.
I heard that the 'magic cookie' (the three init.ora events) enables an alpha version of bitmap indexes in earlier releases of 7.3.2. This pre-beta feature lacks the full functionality of 7.3.2.3's bitmap indexes, and is buggy.
I strongly recommend against using the events, particularly in a production database.
>Thanks!
>
>Lisa
>
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD
http://govt.us.oracle.com/ -- downloadable utilities