RE: bitmap indexes in 7.3.4

From: Singla, Sanjeev <SSingla_at_oxhp.com>
Date: Fri, 23 Jun 2000 12:16:20 -0400
Message-Id: <10537.110286@fatcity.com>

This is wierd. Bitmap indexes is nothing to do with parallel query option. Parallel query option comes default whereas bitmap indexes options comes only
in Enterprise Edition. More over, there is no separate parallel query option.
It may be true for Oracle 7.x but definitely not for Oracle 8.x See the v$option.

Anyway.

-----Original Message-----
From: Rachel Carmichael [mailto:carmichr_at_hotmail.com] Sent: Friday, June 23, 2000 10:43 AM
To: Multiple recipients of list ORACLE-L Subject: Re: bitmap indexes in 7.3.4

Okay...... we figured out the problem. We have Enterprise Edition but you also need to have parallel query running.....

as it turns out, it's academic.... the distribution (over 400,000 rows) on a

yes/no columns is 13 rows yes, the remainder no

>From: "Rachel Carmichael" <carmichr_at_HOTMAIL.COM>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: bitmap indexes in 7.3.4
>Date: Fri, 23 Jun 2000 02:15:33 -0800
>
>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).

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

Received on Fri Jun 23 2000 - 11:16:20 CDT