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 ?

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

0 Answers   Oracle, TCS,

when do u go for hash partitioning?

1 Answers  

Explain the use of log option in exp command.

0 Answers  

How to define a variable to match a table column data type?

0 Answers  

How to handle a single quote in oracle sql?

0 Answers  

what is cartesian product?

2 Answers  

Explain the use of grant option in exp command.

0 Answers  

What is the difference between hot backup and cold backup in oracle?

0 Answers  

Explain temporal data types in oracle

0 Answers  

what is the difference between no rows returned and null returned?

2 Answers  

Explain a private synonyms?

0 Answers  

master table and child table performances and comparisons in Oracle ?

0 Answers