Re: Bitmap indexes

From: Mohamad SALEH <msaleh_at_orsys.fr>
Date: Mon, 21 Jun 1999 13:11:43 +0200
Message-ID: <376E1DEF.2B1E55E9@orsys.fr>

Chris Hamilton a écrit :

On Thu, 15 Apr 1999 15:30:10 +0100, Des Collins
<desmond.collins@removeme.bt.com> wrote:

>Ivan,
>
>If you run,
>
>select * from dba_indexes
>where uniqueness = 'BITMAP'
>
>this shows all bitmap indexes - and you can work on from there

That's not correct, at least not in 8.0.5.  There is an INDEX_TYPE
column.

select * from dba_indexes
where index_type = "BITMAP';

The UNIQUENESS column contains only the values UNIQUE and NONUNIQUE.

Chris
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Christopher Hamilton
Oracle DBA -- Wall Street Sports
chris@wallstreetsports.com
http://www.wallstreetsports.com/

In oracle 7, it is the UNIQUENESS column which hold this information.
  Received on Mon Jun 21 1999 - 06:11:43 CDT