Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

What Index Type Index is

Posted on 2013-05-27
5
Medium Priority
?
551 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Suggested Courses

564 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