Re: Bitmap indexes

From: <acedba_at_my-dejanews.com>
Date: Fri, 07 May 1999 13:01:02 GMT
Message-ID: <7guo6b$46n$1@nnrp1.deja.com>

More specifically, Ivan, you can get this information from the index_type column in dba_indexes or user_indexes.

In article <372F1D31.A981204_at_erols.com>, Madhu Bandireddy <nilu_at_erols.com> wrote:
> yes u can get the info from dba_indexes as the unique or nounique, ie
> b-tree for unique & bitmap for nonunique
>
> nilima
>
> Ivan Bajon wrote:
>
> > Does anyone know how to determine from the data dictionary whether an
> > index
> > is a b-tree or a bitmap index? Dba_indexes doesn't seem to carry that
> > information.
> >
> > Regards,
> > Ivan Bajon
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri May 07 1999 - 08:01:02 CDT