What Index Type Index is

I create a table with 100 partitions.
I create a primary key on the table.
How do i know what kind of index is built on the table: btree index, bitmap index, global index, local index, cluster index, reverse key index


ALTER TABLE abc ADD (
  CONSTRAINT PK_abc
  PRIMARY KEY
  (col1, col3)
  USING INDEX PK_abc);

On checking indes_type i get the following indexes. These does not indicate any of the above indexes.
IOT - TOP
FUNCTION-BASED DOMAIN
FUNCTION-BASED NORMAL
LOB
NORMAL
DOMAIN
CLUSTER
gram77Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Alexander Eßer [Alex140181]Connect With a Mentor Software DeveloperCommented:
I suppose it must be stored as b-tree index:

http://docs.oracle.com/cd/E18283_01/server.112/e16508/indexiot.htm
0
 
Franck PachotCommented:
You find it with:
Select index_type from user_indexes where index_name='PK_abc'

If the index was not there before, then Oracle creates a NORMAL index.
0
 
gram77Author Commented:
Yes I found Oracle creates an index of type Normal! Now what kind of an index Normal is?
0
 
mohammadzahidCommented:
By default Oracle created b-tree indexes and this applies to Primary key constraint and
CREATE INDEX.... command.
0
 
Franck PachotConnect With a Mentor Commented:
Hi, NORMAL is à b-tree where each entry has a pointer to the table row (rowid)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.