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 many types of tables supported by oracle?

578


Where are the settings stored for each instance in oracle?

621


How can I get column names from a table in oracle?

534


How does oracle handle read consistency?

676


How to insert multiple rows with one insert statement in oracle?

570






Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

608


How to define an anonymous block?

617


What is the difference between online and offline backups?

560


How to rename an index in oracle?

614


What is format trigger?

1616


What are nested tables?

671


What does sharding mean?

539


In what script is snap$ created? In what script is the scott/tiger schema created?

2243


What is an oracle tablespace?

604


What are temporal data types in oracle?

596