Answer / swapna

We have mainly two different indexes .

Implicit index and Explicit index.

Explicit indexes are again of many types like
simple index,unique index,Bitmap index,Functional
index,Organisational index,cluster index.

Answer / gnskannan

Indexes in Oracle are as follows.....

1.Normal index
Whenever we created a column(s) with Primary key or
Unique constraints ,Oracle implicitly creates Normal
index.This index is not Unique index .Why because those
columns already having uniqeness because of Unique or
Primary key constriants.

2.Bitmap indexs
3.Function based indexs
4.Domain indexes.
if we want to create Unique indexes we have to use Unique
keyword when we are creating indexes.

But if you refer Oracle 9i corporation books you can read
as follows...

They gave these statement in wrong.

Indexes can be created in two types

1.Unique indexes(Oracle creates it implicitly whenever we
created column(s) with PK or Unique constraints

2. Non unique indexes
This indexes can be created by developers

Answer / nimisha

Implicit index and Explicit index.

Answer / siva

There are four reguler types of Indexes in oracle
1.Normal index
2.Bitmap indexs
3.Function based indexs
4.Domain indexes.

The custom and recommended types are of 2 types
Implicit index and Explicit index.

Answer / ananthram

Just and Addition to the above discussion.
I cant agree completely with answer #3 when it says
"This index is not Unique index "
Because Oracle makes sure that the uniqueness is maintained
in case of Primary and unique key by imposing UNIQUE INDEX
on it.
So I find it difficult when someone says that the implicit
indexes created by oracle while the creation of PK and UK
are not UNIQUE indexes.

Answer / ron

some more additions to the above:
context indexes etc. you can read about it here:
http://www.databasedesign-resource.com/oracle-indexes.html
hope this helps.

Answer / satya krishna

B-TREE INDEX, BITMAP INDEX, REVERSE INDEX, FUNCTION-BASED INDEX, ASCENDING & DESCENDING INDEX, Cluster indexes, bitmap join indexes, text indexes, Hash cluster indexes, DOMAIN INDEXES.

Indexes are logically and physically independent of the data in the associated table.

ONCE AFTER CREATING THE INDEX ORACLE WILL AUTOMATICALLY HANDLE IT LATER.

Answer / surya

some more additions to the above:

Reverse key index

Answer / srinivasarao

total indexes are in oracle is 5
1.b tree
2.bitmap
3.function_based
4.domain
5.ascending or descending

Answer / venkat rao

Normal index
Bitmap index
partitioned index
Function based index
Domain index
composite index

What is archive log in Oracle?

0 Answers   MCN Solutions,

What is the difference between implicit index and explicit index?

2 Answers   TCS,

How to load data from external tables to regular tables?

0 Answers  

HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG WITH DEPARTMENT NAMES? E.g EMP,DEPT

5 Answers   College School Exams Tests, DELL,

Explain the importance of .pll extension in oracle?

0 Answers  

What are privileges and grants?

0 Answers  

What are the attributes that are found in a cursor?

0 Answers  

How to bring a tablespace online?

0 Answers  

what is foreign key?

5 Answers  

What is a OUTER JOIN?

1 Answers  

What is currency type in database ?

3 Answers   TCS,

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

0 Answers