Re: bitmap index on 7.3.3

From: Coburn Watson <cpw_at_jps.net>
Date: Wed, 13 May 1998 23:11:18 -0800
Message-ID: <cpw-1305982311180001@oak-port1849.jps.net>

From what I know about bitmap indexes is that it shouldn't be a function of SQL*Plus or rely on the presence of parallel query being utilized. It is simply an index, primarily for use on columns with low cardinality. Sorry, I really can't offer an answer immediately, but I believe you shouldn't have to look beyond the bitmap index docs.

Coburn Watson
dba
cpw_at_jps.net

In article <6j3dg5$iep_at_bgtnsc03.worldnet.att.net>, Michael Serbanescu <mserban_at_postoffice.worldnet.att.net> wrote:

> 1) Check the value of the INIT.ORA parameter COMPATIBLE (should be set to at
> least 7.3.2)
>
> 2) Maybe the version of SQL*Plus that you are running does not support
the CREATE
> BITMAP INDEX syntax. To verify this assumption, try to create the bitmap
index using
> the Server Manager or the SQL*Worksheet utility from the Enterprise
Manager (if you
> have it).
>
> Hope this helps.
>
>
>
>
> Michael Serbanescu
>

---

> ocmohan_at_iname.com wrote:
> >
> > Hi gurus,
> > I have been trying to create a bitmap index on a column.
> > When I issue the CREATE BITMAP INDEX ON ... command, I get ORA-00901 -
invalid
> > create statement. ORACLE documentation states that to create an index as a
> > bitmap index, use the BITMAP keyword after the CREATE word. (The SQL
Reference
> > manual does not talk anything about BITMAP INDEXES though). Has anyone
> > successfully created bitmap indexes on ORACLE 7.3? Any help would be greatly
> > appreciated.
> >
> > Other information you may want to know :
> > * I have 2 test machines (Window 95), one with Personal Oracle 7.3.2 and one
> > with 7.3.4.
> > * According to ORACLE documentation, the compatibility has to be 7.3.2 or
> > higher in order to use bitmap indexes. On one machine I set compatibility to
> > 7.3.2 and on the other it is 7.3.3
> > * I also set the init parameter p_bitmap_tree_plans to true.
> > * The column I am trying to use bitmap index has a low cardinality (2 values
> > 'NAT' and 'ORG')
> >
> > Thanks in advance,
> > CM
> >
> > -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> > http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Thu May 14 1998 - 02:11:18 CDT