Answer / rajesh

Mainly Two type of Index in Oracle.
1:-> Logical
2:-> Physical

1:-> Unique,Non Unique,Function
2:-> B-Tree & Bitmap

Answer / sudev kuma rmishra

two types
A.implicit B.explicit

A.implicit index

automatically created when we mention primary key or unique key

B.explicit index

these are created by user
and examples are
1.simple/normal index
2.composite index
3.unique index
4.bitmap index
5.partition index
6.function index

Answer / kumar swamy naidu

1.implicit

2.explicit
2.1.simple/b+tree index
2.2.bitmap index
2.3.reserved key index
2.3.composite index
2.4.function based index
2.5.partition index
2.6.domain index
2.7.text index
2.8.cluster index

Answer / gaurav kukreja

mainly two type of indexes
1:- logical
2:- physical
logical indexes are also two type.. uniqe and functional
based indexes.
functional indexes are also two type...b-treeand bit map
indexes....

indexes are also used in searching and sorting

Answer / debasis mohanty

INDEX Are Of 4 Types
1.NORMAL OR SIMPLE OR B-TREE Index
2.BITMAP INDEX
3.COMPOSITE INDEX
4.FUNCTION BASED INDEX

Answer / vipul.solanki

Index is use for the performance to retrieve data from table.
1 . index automatically created when create PK or UK
2 . Explicitly create index

there is three type of index

1.unique index
2.cluster index
3.non-cluster index

Answer / nagaraju

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 / gouranga mohapatra

There are several types of indexes available in Oracle all
designed for different circumstances:
•b*tree indexes - the most common type (especially in OLTP
environments) and the default type
•b*tree cluster indexes - for clusters
•hash cluster indexes - for hash clusters
•reverse key indexes - useful in Oracle Real Application
Cluster (RAC) applications
•bitmap indexes - common in datawarehouse applications
•partitioned indexes - also useful for datawarehouse
applications
•function-based indexes
•index organised tables
•domain indexes

Answer / vicky

Mainly indexes are 3 types:
1:-functional based index
2:-bit map index
3:-b-tree index

Answer / vawani

Then what is Clustered Index and Non-Clustered Index ?

How to drop a stored function?

0 Answers  

What is a lookup table in oracle?

0 Answers  

Explain the use of control file?

0 Answers  

When does a Transaction end ?

2 Answers  

What is the Tune Query

0 Answers  

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

0 Answers   ESS,

what is the output of select * from emp where null=null & select * from emp where 1=1

8 Answers   IMS Health, NIIT,

how to find find & delete duplicate rows from two different tables?

3 Answers   Accenture, TCS,

How to get a list of all tables in the database?

1 Answers  

What is a proxy class?

0 Answers  

I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?

5 Answers   Zensar,

What is a subquery?

0 Answers