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

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

1880


How do I connect to oracle?

562


What to do if the binary spfile is wrong for the default instance?

563


What are the set operators union, union all, minus & intersect meant to do?

563


How to calculate date and time differences in oracle?

533






Give the various exception types.

545


How can I create database in oracle?

569


What is logical backup in oracle?

578


What is the difference between sharding and partitioning?

503


Describe varray?

588


What are nested tables?

673


How to use "while" statements in oracle?

737


What is the difference between view and materialized view in Oracle?

608


What is raw datatype?

593


Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

934