How many different types of indexes we have in oracle?
Answer Posted / swapna
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 ? | 179 Yes | 64 No |
Post New Answer View All Answers
Which environment variables are absolutely critical in order to run the OUI?
What are the four Oracle system processes that must always be up and running for the database to be useable?
What is a lookup table in oracle?
What happens to the current transaction if the session is ended?
How to use regular expression in pattern match conditions in oracle?
What is the data type of dual table?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
What suggestions do you have to reduce the network traffic?
What are the limitations oracle database 10g xe?
How to create a table index in oracle?
How to lock and unlock a user account in oracle?
What are the different pseudo commands? Explain in general?
Can you create a synonym without having a table?
Give the different types of rollback segments.
What is a sub query? Describe its types?