Interested to Buy Any Domain ? << Click Here >> for more details...
How many different types of indexes we have in oracle?
- 24 Answers
- 192589 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rajesh
Mainly Two type of Index in Oracle.
1:-> Logical
2:-> Physical
1:-> Unique,Non Unique,Function
2:-> B-Tree & Bitmap
| Is This Answer Correct ? | 4 Yes | 0 No |
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
| Is This Answer Correct ? | 4 Yes | 1 No |
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
| Is This Answer Correct ? | 3 Yes | 0 No |
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
| Is This Answer Correct ? | 13 Yes | 11 No |
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
| Is This Answer Correct ? | 3 Yes | 1 No |
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
| Is This Answer Correct ? | 3 Yes | 1 No |
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.
| Is This Answer Correct ? | 2 Yes | 0 No |
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
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / vicky
Mainly indexes are 3 types:
1:-functional based index
2:-bit map index
3:-b-tree index
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / vawani
Then what is Clustered Index and Non-Clustered Index ?
| Is This Answer Correct ? | 2 Yes | 1 No |
What is oracle database client?
what is the syntax of INSERT command?
Is insert autocommit in oracle?
What are a cluster and non-cluster index?
How to use "out" parameter properly?
what is dynamic SGA and static SGA
i want to know about mr.b.kotravel......who has answered for second maxmium salary from employee table
What are the most common interview questions on ETL Testing for experience?
Difference between primary key and unique key ?
77 Answers Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions,
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
What is a oracle database?
13. Display the second to fifth characters in each client name.
Oracle General 
