gram77
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
CREATE INDEX.... command.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Select index_type from user_indexes where index_name='PK_abc'
If the index was not there before, then Oracle creates a NORMAL index.