RE: bitmap indexes in 7.3.4

Scott,

Thanks for clearing this up! At the other job, we did have parallel query installed, so of course bitmap indexes worked. We do NOT have it installed here, and, as I have found that the distribution is 13 rows out of over 400,000 have one value (Y) while all the others have the second value (N) and the queries will be selecting for the N, I don't think a bitmap will help anyway.

Now what I REALLY want to do is move this application to 8i.

Rachel

>From: sheisey_at_att.net
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: bitmap indexes in 7.3.4
>Date: Fri, 23 Jun 2000 18:04:19 -0800
>
>Sanjeev, Actually the e-mails regarding what is need to
>get Bitmap indexes running on Oracle 7.3 are not
>incorrect. The e-mail Ron sent out on the events is what
>you had set in version 7.3.2 to get bitmap indexes to
>work. You can refer to bug 388925 for more information on
>this. This bug will tell you about the events and the
>fact that the PQ had to be installed with the enterprise
>edition for bitmap indexes to work. You can also look at
>bug 489482 for additional information.
>
>Scott
> > I worked a lot on bitmap in 7.3.4 last year. There is no such
>requirement.
> > Only requirement is enterprise edition.
> >
> > -----Original Message-----
> > Sent: Friday, June 23, 2000 12:58 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Rachel
> > Not having the opportunity to use bitmaps but doing a lot of reading,
>maybe
> > I can offer a suggestion from my readings;
> > event ="10111 trace name context forever"
> > event ="10112 trace name context forever"
> > event ="10114 trace name context forever"
> > must be set for bitmaps to work and turn on specific pieces of code in
>the
> > Oracle kernal.
> > per Micheal Ault.
> > I may be offbase with this suggestion but like I said I haven't used
>bitmaps
> > yet.
> > Hop it helps,
> > Ron Rogers
> > DBA
> > Atl.GA
> >
> > >>> carmichr_at_hotmail.com 06/23/00 06:15AM >>>
> > Okay, even goddesses need help sometimes :)
> >
> > I KNOW I can create bitmap indexes in 7.3.4, I've done it at other jobs.
>But
> >
> > for the life of me, I can't remember what it is that I need to do that I
>am
> > not already doing....
> >
> > v733_plans_enabled=true
> > compatible=7.3.4.0
> >
> > and I say "create bitmap index indexname on tablename(column)"
> >
> > and it barfs on the word bitmap.....
> >
> > so what am I doing wrong????
> >
> > THANKS!!!
> >
> > Rachel
> > ________________________________________________________________________
> > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
> >
> > --
> > Author: Rachel Carmichael
> > INET: carmichr_at_hotmail.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> > --
> > Author: Ron Rogers
> > INET: RROGERS_at_galottery.org
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> > --
> > Author: Singla, Sanjeev
> > INET: SSingla_at_oxhp.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>--
>Author:
> INET: sheisey_at_att.net
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).