Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

What Index Type Index is

Posted on 2013-05-27
5
Medium Priority
?
549 Views
Last Modified: 2013-05-30
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
0
Comment
Question by:gram77
5 Comments
 
LVL 14

Accepted Solution

by:
Alexander Eßer [Alex140181] earned 1000 total points
ID: 39199027
I suppose it must be stored as b-tree index:

http://docs.oracle.com/cd/E18283_01/server.112/e16508/indexiot.htm
0
 
LVL 15

Expert Comment

by:Franck Pachot
ID: 39199594
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
 

Author Comment

by:gram77
ID: 39199602
Yes I found Oracle creates an index of type Normal! Now what kind of an index Normal is?
0
 
LVL 11

Expert Comment

by:mohammadzahid
ID: 39199634
By default Oracle created b-tree indexes and this applies to Primary key constraint and
CREATE INDEX.... command.
0
 
LVL 15

Assisted Solution

by:Franck Pachot
Franck Pachot earned 1000 total points
ID: 39200277
Hi, NORMAL is à b-tree where each entry has a pointer to the table row (rowid)
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses

886 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question