Interested to Buy Any Domain ? << Click Here >> for more details...
How many different types of indexes we have in oracle?
- 24 Answers
- 192814 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / gnskannan
Indexes in Oracle are as follows.....
1.Normal index
Whenever we created a column(s) with Primary key or
Unique constraints ,Oracle implicitly creates Normal
index.This index is not Unique index .Why because those
columns already having uniqeness because of Unique or
Primary key constriants.
2.Bitmap indexs
3.Function based indexs
4.Domain indexes.
if we want to create Unique indexes we have to use Unique
keyword when we are creating indexes.
But if you refer Oracle 9i corporation books you can read
as follows...
They gave these statement in wrong.
Indexes can be created in two types
1.Unique indexes(Oracle creates it implicitly whenever we
created column(s) with PK or Unique constraints
2. Non unique indexes
This indexes can be created by developers
| Is This Answer Correct ? | 83 Yes | 28 No |
Answer / siva
There are four reguler types of Indexes in oracle
1.Normal index
2.Bitmap indexs
3.Function based indexs
4.Domain indexes.
The custom and recommended types are of 2 types
Implicit index and Explicit index.
| Is This Answer Correct ? | 39 Yes | 8 No |
Answer / ananthram
Just and Addition to the above discussion.
I cant agree completely with answer #3 when it says
"This index is not Unique index "
Because Oracle makes sure that the uniqueness is maintained
in case of Primary and unique key by imposing UNIQUE INDEX
on it.
So I find it difficult when someone says that the implicit
indexes created by oracle while the creation of PK and UK
are not UNIQUE indexes.
| Is This Answer Correct ? | 32 Yes | 9 No |
Answer / ron
some more additions to the above:
context indexes etc. you can read about it here:
http://www.databasedesign-resource.com/oracle-indexes.html
hope this helps.
| Is This Answer Correct ? | 42 Yes | 31 No |
Answer / satya krishna
B-TREE INDEX, BITMAP INDEX, REVERSE INDEX, FUNCTION-BASED INDEX, ASCENDING & DESCENDING INDEX, Cluster indexes, bitmap join indexes, text indexes, Hash cluster indexes, DOMAIN INDEXES.
Indexes are logically and physically independent of the data in the associated table.
ONCE AFTER CREATING THE INDEX ORACLE WILL AUTOMATICALLY HANDLE IT LATER.
| Is This Answer Correct ? | 12 Yes | 1 No |
Answer / surya
some more additions to the above:
Reverse key index
| Is This Answer Correct ? | 18 Yes | 8 No |
total indexes are in oracle is 5
1.b tree
2.bitmap
3.function_based
4.domain
5.ascending or descending
| Is This Answer Correct ? | 27 Yes | 17 No |
Answer / venkat rao
Normal index
Bitmap index
partitioned index
Function based index
Domain index
composite index
| Is This Answer Correct ? | 8 Yes | 1 No |
How to display row numbers with the records?
1) Does oracle have any table which contain all the exceptions and it's code internally?
How oracle handles dead locks?
How to convert character types to numeric types?
How many anonymous blocks can be defined?
How to check the oracle tns settings?
How will you write a query to get a 5th rank student from a table student_report?
What do you mean by merge in oracle and how can we merge two tables?
How does the on-delete-cascade statement work?
Does oracle charge for java?
1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.
how to clone 9i Database on to 10g Database.
Oracle General 
