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 oracle a relational database?

0 Answers  

What are the differences between lov and list item?

0 Answers  

what is primary key and foreign key when and where have to use

5 Answers  

What is a nested table?

0 Answers  

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

0 Answers   IBM,

structural difference between bitmap and btree index ?

1 Answers   Infosys,

I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??

1 Answers  

Display Odd/ Even number of records?

3 Answers  

SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?

1 Answers   ESS,

What is the CAP theorem?

1 Answers  

What do you know about normalization? Explain in detail?

0 Answers  

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

8 Answers   IMS Health, NIIT,