Interested to Buy Any Domain ? << Click Here >> for more details...
How many different types of indexes we have in oracle?
- 24 Answers
- 192542 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 |
Explain the features of oracle?
How to use subqueries in the from clause in oracle?
How a tablespace is related to data files?
What is the use of aggregate functions in oracle?
what are the different types of cursors? explain?
How to convert dates to characters in oracle?
How do I know if oracle is installed on windows?
What is meant by raw datatype?
What is data block in Oracle?
Explain a private synonyms?
Explain the characteristics of oracle dba?
What is the relation of a user account and a schema?
Oracle General 
