Re: Bitmap indexes

From: Chris Hamilton <ToneCzar_at_erols.com>
Date: Thu, 15 Apr 1999 14:36:30 GMT
Message-ID: <3715f914.11182800@news.erols.com>

On Thu, 15 Apr 1999 15:30:10 +0100, Des Collins <desmond.collins_at_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_at_wallstreetsports.com
http://www.wallstreetsports.com/ Received on Thu Apr 15 1999 - 09:36:30 CDT