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


Please Help Members By Posting Answers For Below Questions

what is the scenario where you take the database to NoArchivelog mode?

2086


Explain constraining triggers.

881


how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5090


What is a view and how is it different from a table?

760


what is meant by magic query

1992


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?

1757


Difference between cartesian join and cross join?

803


Can we store pictures in the database and if so, how it can be done?

827


Explain what are the advantages of views?

841


State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

826


How to omit columns with default values in insert statement in oracle?

841


How do I find my oracle client driver version?

772


How to resolve name conflicts between variables and columns?

827


Is primary key indexed by default in oracle?

769


How to create a new user account in oracle?

815