How many different types of indexes we have in oracle?

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


Please Help Members By Posting Answers For Below Questions

How to rename an existing table?

800


Explain the use of indexes option in exp command.

787


What is meant by joins? List out the types of joins.

730


Is oracle an operator?

714


How to connect to oracle using service name instead of sid?

790


How to resolve the ORA-39133 error in Oracle?

807


Why do we use bulk collect in oracle?

817


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

5065


Explain oracle insert into command?

855


HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

1207


How to test null values?

856


What is merge statement used for?

774


What is the meaning of recursive hints in oracle?

772


How to declare a local variable?

822


What are data pump export and import modes?

830