Interested to Buy Any Domain ? << Click Here >> for more details...
How many different types of indexes we have in oracle?
- 24 Answers
- 191816 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 tns service name?
What is translate in oracle?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
How do we get field detail of a table?
difference between imlicit cursor and explicit cursor ?
What is the quickest way to fetch the data from a table?
How to use "out" parameter properly?
Explain the difference between sql and oracle?
How to call a stored function in oracle?
What is an anonymous block?
Is oracle an operator?
A VIEWS takes memory in the database. If yes, how can u proove it? is there any way to display the size of views?
Oracle General 
