How many different types of indexes we have in oracle?
Answer Posted / 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 |
Post New Answer View All Answers
What is Reduced List of Values?
What is max rowid in oracle?
How a tablespace is related to data files?
What are the logical operations?
What are oracle functions?
What is set operator oracle?
How do I connect to oracle database?
Explain the use of ignore option in imp command.
What is a Garbage Collection? and what is full recursive Garbage collection?
Explain alias?
What is the difference between postgresql and oracle?
In what script is snap$ created? In what script is the scott/tiger schema created?
What is a subquery in oracle?
Can a formula column referred to columns in higher group ?
How can we find out the duplicate values in an oracle table?