HOw to find whether an index is bitmap

[Former Member]

I am using ST02 and DB02 transaction. I went in detail analysis, search for indexes. But do not know where ti look whether index is bitmap. Where to look to get this information?

[Former Member]

Hi,

If your database version is 9.2 then it usage bitmap index (Default setting as of Oracle Release 9.2). As of oracle 9i Oracle usage locally managed tablespaces. if you are managing your tablespaces by LMTS then index used is of type bitmax.

Check below SAP notes for more details.

Note 214995. - Oracle locally-managed tablespaces in the SAP environment

Note 409376 - Use of locally managed tablespaces for SAP R/3

Thanks

Sushil

[fidel_vales]

Hi,

sorry but you are quite wrong.

The OP is talking about indexes and you are talking about TABLESPACES.

those two are quite different.

to check quickly if an index is bitmap or not check the output of the following query:

select INDEX_TYPE

from dba_indexes where

index_name=<your index>

the output could be one of the following:

NORMAL

BITMAP

FUNCTION-BASED NORMAL

FUNCTION-BASED BITMAP

DOMAIN

in SAP only the first two are used