Link to home
Start Free TrialLog in
Avatar of gram77
gram77Flag for India

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of Alex [***Alex140181***]
Alex [***Alex140181***]
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
Avatar of gram77

ASKER

Yes I found Oracle creates an index of type Normal! Now what kind of an index Normal is?
By default Oracle created b-tree indexes and this applies to Primary key constraint and
CREATE INDEX.... command.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial