Find out INDEX type ?? for INDEX Key Compressions. !!!

[former_member69568]

Hi... Experts

How to identify the Index Type in ABAP System.

In general SAP Uses most ofB*Tree indexes

There 6 Types of Indexed as U Aware

01. B*Tree indexes

02. Bitmap indexes

03. Reverse key indexes

04. Unique indexes

05. Non-unique indexes

06. Index organized tables

SQL Statemnt :select TABLE_NAME,INDEX_NAME,index_type from dba_indexes where TABLE_NAME='TABLE_NAME';

Giving as NORMAL.

do we need to assume NORMAL = BTREE Indexes as SAP mostly used BTree.

(or)

any other way to foind out INDEX type as we are planning Index Compressions.( Note / 1109743)

 912620 - FAQ: Oracle indexes reviewed  // but did not get answer to our question

Rgds

[fidel_vales · Accepted solution]

hello,

in a "normal" R/3 only Btree indexes are used.

BITMAP indexes are used in BW.

Of course, now SAP has "mixed" type applications that could use __BTREE__ BITMAP (correction).

Nevertheless, the command you used is the correct one to find the index type.

the documentation tells you the possible values for index_type:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_1069.htm#i1578369

"NORMAL" is the typical Btree index.

UNIQUE or NONUNQUE is not a different type of index.

IOT are tables, not indexes

Edited by: Fidel Vales on Jul 13, 2009 5:02 PM

[Former Member]

Hi,

Check

& SAP Note 912620 - FAQ: Oracle indexes.

Hope it helps

Thanks

Sushil

[former_member69568]

>>FIND SIZE OF INDEX

Example Query:

SQL> select segment_name index_name, partition_name, round (bytes/1024/1024) MB

2 from user_segments

3 where segment_name = 'FAGLFLEXA~0';

Example Result :

INDEX_NAME--

---

PARTITION_NAME--

---

MB

FAGLFLEXA~0--

---

###############--

---

4750

SQL>