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
what is the scenario where you take the database to NoArchivelog mode?
Explain constraining triggers.
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
What is a view and how is it different from a table?
what is meant by magic query
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Difference between cartesian join and cross join?
Can we store pictures in the database and if so, how it can be done?
Explain what are the advantages of views?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
How to omit columns with default values in insert statement in oracle?
How do I find my oracle client driver version?
How to resolve name conflicts between variables and columns?
Is primary key indexed by default in oracle?
How to create a new user account in oracle?