total indexes are in oracle is 5 1.b tree 2.bitmap 3.function

How many different types of indexes we have in oracle?

Question Posted / srinivasarao

Answer Posted / srinivasarao

total indexes are in oracle is 5
1.b tree
2.bitmap
3.function_based
4.domain
5.ascending or descending

Is This Answer Correct ?

27 Yes

17 No

Please Help Members By Posting Answers For Below Questions

What is primefaces used for?

1006

What is an oracle function?

1072

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2574

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1844

ABOUT IDENTITY?

2005

Can a formula column be obtained through a select statement ?

2264

Explain the difference between sql and oracle?

1023

What is the difference between count (*), count (expression), count (distinct expression)?

964

Please explain oracle data types with examples?

990

Can select statements be used on views in oracle?

982

What is clustered table in Oracle?

1106

How to do paging with oracle?

949

What privilege is needed for a user to connect to oracle server?

939

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1943

How to fetch the row which has the max value for a column?

947