How many different types of indexes we have in oracle?
- 24 Answers
- 185608 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain what are the type of synonyms?
What are the benefits of ordbms?
How to define an anonymous procedure without variables?
How to estimate disk space needed for an export job?
How to turn on or off recycle bin for the session?
Can multiple cursors being opened at the same time?
Can you create a synonym without having a table?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
How can we view last record added to a table?
Explain an integrity constrains?
What is the difference between count (*), count (expression), count (distinct expression)?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
What do you mean by merge in oracle?
How to resolve name conflicts between variables and columns?
State any two functions of oracle?
