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

How to update values on multiple rows in oracle?

0 Answers  

how can db_files > maxdatafiles since db_files is for instance and the later is for database

0 Answers   CTS,

Why do we use coalesce function in oracle?

0 Answers  

In the oracle version 9.3.0.5.0, what does each number shows?

0 Answers  

What is Normalization ?

55 Answers   ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault,

How to get execution statistics reports on query statements?

0 Answers  

What are cursor?where are they used?

2 Answers  

what is the syntax of CREATE command?

8 Answers  

What privilege is needed for a user to create views in oracle?

0 Answers  

6. Display the client name and order date for all orders using the traditional method.

0 Answers   Wipro,

Can I create users through internet explorer in oracle 10g?

0 Answers   MCN Solutions,

How to synchronize 2 schema's objects?

0 Answers   Virtusa,